Why do you create or replace procedures rather that drop and recreate.
No Answer is Posted For this Question
Be the First to Post Answer
List the parts of a database trigger.
What do you understand by database schema and what does it hold?
What is meant by joins? List out the types of joins.
What do you mean by merge in oracle and how can we merge two tables?
What are the different windows events activated at runtime ?
What is a trigger and what are its types?
Explain the use of owner option in exp command.
What is different types of joins?
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.
How do we create privileges in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
what is a view?