How to check the server version in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
can you call insert/update/delete in select statements. If yes how? If no what is the other way?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
Why is oracle used?
What is oracle database 10g express edition?
What is a sub query and what are the different types of subqueries?
How you open and close a cursor variable.Why it is required?
What are the differences between char and varchar2 in oracle?
how will I find the first 5 highest salaried employees in each dept in oracle.
How to omit columns with default values in insert statement in oracle?
What operating systems are supported by oracle database 10g xe?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me