SELECT attr1,attr2..attrn FROM TABLE1,TABLE2..TABLEn; (IT IS SIMPLE SELE

what is the syntax of SELECT command?

Question Posted / mohammed ashfaq

6 Answers
8297 Views
I also Faced
E-Mail Answers

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

what is meant by magic query

2177

What are the differences between lov and list item?

1058

please explain.. DB architecture ...

2015

How to write date and time interval literals in oracle?

1028

How to create additional tablespaces for an new database?

1020

List the various oracle database objects?

1053

How to do clean up if create database failed?

1026

How do I uninstall oracle client from windows?

1007

What is format trigger?

2062

How to assign a table row to a record variable?

1035

What is the difference between Delete, Truncate and Drop in Oracle?

1127

What is bind variable in oracle 11g?

1037

How to connect asp pages to oracle servers?

1069

What are the data types in oracle?

1035

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2463