Explain the use of record option in exp command.
No Answer is Posted For this Question
Be the First to Post Answer
What privilege is needed for a user to create indexes in oracle?
What is a subquery?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
How to rollback the current transaction in oracle?
Explain how are indexes update?
What is meant by joins?
Explain a data segment?
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.
is there a tool to trace queries, like profiler for sql server?
which clause we are not used in where clause?
How to revoke create session privilege from a user in oracle?