What happens if the update subquery returns multiple rows?
No Answer is Posted For this Question
Be the First to Post Answer
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
what is trigger?
Explain 1st, 2nd, 3rd normalization form of data base
Explain the use of tables option in exp command.
Difference between pre-select and pre-query
Who i will insert 1 lacks record in a Database table
WHAT IS ecc 6.0
Explain constraining triggers.
How to call a stored function with parameters?
How to bring a tablespace online?
What is a package ? What are the advantages of package ?
Can we write insert statement in function in oracle?