Answer Posted / vawani sankar naik
SELECT * FROM TABLE WHERE 1=2;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
what is a Nested Loop join?
How to convert csv to table in oracle?
How to get execution statistics reports on query statements?
Explain the use of analyse option in exp command.
What is materialized view in Oracle?
Explain the use of consistent option in exp command.
Where do we use decode and case statements?
What is the difference between view and materialized view in Oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is the difference between truncate & delete command?
How to retrieve data from an explicit cursor?
How to delete multiple rows from a table in oracle?
Why oracle is used?
How to view the tablespaces in the current database?