what is the syntax of SELECT command?

Answer Posted / mohammed ashfaq

SELECT attr1,attr2..attrn
FROM TABLE1,TABLE2..TABLEn;
(IT IS SIMPLE SELECT)
(FOR COMPLEX SELECT)
SELECT attr1,attr2..attrn
FROM TABLE1,TABLE2..TABLEn
WHERE CONDITION;

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use select statement to count the number of rows in oracle?

557


How to install oracle odbc drivers?

623


Explain implicit cursor.

558


What is columnar storage what is the advantage?

546


How to delete a user account in oracle?

551






How to loop through a cursor variable?

569


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.

1536


Give the various exception types.

549


What are the most common interview questions on ETL Testing for experience?

597


What is an external table?

588


What would you do with an in-doubt distributed transaction?

1469


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1758


what is port in oracle? how is it related to database application.

1438


Explain what are the different type of segments?

580


How to open a cursor variable?

611