Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is a table index in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How to create additional tablespaces for an new database?
What do you understand by a database object? Can you list a few of them?
Can we insert data in view oracle?
What is instant client oracle?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How can I combine multiple rows into a comma-delimited list in oracle?
What is meant by raw datatype?
List out the components of logical database structure of oracle database.
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is using clause and give example?
What is an oracle transaction?
What is varray?
