How to display First 4 rows From Database Table?

Answer Posted / rathi.sql

select * from employees
where rownum<=4

Is This Answer Correct ?    24 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use an explicit cursor without open statements?

616


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1539


Explain what are the uses of rollback segment?

588


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

1633


What is a tns file?

502






How view is different from a table?

560


What are the built-in functions used for sending Parameters to forms ?

2848


What is a trigger and what are its types?

615


What's dateware house and what's clustor with practicle example

1643


Give the various exception types.

551


How to use subqueries with the in operator using oracle?

614


What are the uses of linked server and explain it in detail?

588


What is the usage of merge statement?

674


State and explain the different types of data models?

538


How do I call oracle stored procedures that take no parameters?

568