-
How to update a rows with opposite gender in Sql?
In Emp table there is a column which consists of gender (Male or Female) ? How should one Can update the Values of Male to Female and Female to Male with a single query ?
-
Can we use function inside a trigger
Is it possible to use function inside a trigger.
-
How can we insert into a table by fetching data from more then one table by using only single command
I have 3 tables , same no of columns ,i want to insert whole the data from all these table into a single table,which also having same no of column and the same data type.
-
-
Passing a Function name in Parameter
Can we pass a function name as a parameter value?? will it have any effect in performance degradation when used in a Large online transaction process?
-
Write the query
A employee getting variable salary like Jan 3000,Feb 5000,Mar 1000 ,Apr 7000,May 500 write query to display his next salary "increse" or "decrese" as compare to previous month ,three column in the employee table empname ,salarydate,salary ?
-
Can i update views in SQL
Can i update views in SQL if yes in what scenarios? if your view is joining multiple tables
-
Open Cursors
If you have an open cursor on a table, modify the same table and commit, what would happen?
-
NO_DATA_FOUND or TOO_MANY_ROW
In PL/SQL if we write select statement with INTO clause it may return two exceptions NO_DATA_FOUND or TOO_MANY_ROW .To avoid these execeptions. How do you write SQL statement in alternative way?
-
Compute Sum
In order to 'Compute Sum' clause in the SQL reports which of the following is mandatory1) Break on 2) Order by 3) Set page size 4) Set feedback