Answer Posted / venkat
select * from emp minus select * from emp where rownum <= (select count(*) - &n from emp);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to execute a stored procedure in oracle?
Explain the characteristics of oracle dba?
How to define a cusotmer as a supplier in ORACLE R12
What is the difference between post-database commit and post-form commit?
How will you differentiate between varchar & varchar2?
How to use "if" statements on multiple conditions?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to create a new table by selecting rows from another table?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is memory advisor in Oracle?
What is a table index?
Explain an index segment?
How do we get field details of a table?
How to get execution path reports on query statements?
Why do we need integrity constraints in a database?