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

Explain the different normalization forms?

813


What is the difference between 10g OEM and 11g OEM?

739


How to connect to the server with user account: sys?

785


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

781


What is different types of joins?

771


Is there a function to split a string in plsql?

780


what is reindexing?

1349


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

1690


What is an oracle cursor variable?

803


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

1919


How to fetch the row which has the max value for a column?

761


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2056


How to execute the package in oracle?

812


What is Reduced List of Values?

1893


what are steps for interface? where is exchange rate defined in which table?

1741