select * from employee Here, employee refers "TABLE NAME" *

what is the syntax of SELECT command?

Question Posted / poovitha

6 Answers
8058 Views
I also Faced
E-Mail Answers

Answer Posted / poovitha

select * from employee

Here,
employee refers "TABLE NAME"
* refers all records in the table

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What happens to the current transaction if the session is ended?

1034

What are the various constraints used in oracle?

991

What are the attributes of the cursor?

934

What is data block in Oracle?

1049

Which are the five query types available in oracle?

895

Write a trigger example in oracle?

980

What happens to the indexes if a table is recovered?

941

What are the different editions of oracle?

1048

What is the use of oracle?

981

Can the query output be sorted by multiple columns in oracle?

934

What are named parameters?

1033

How to set up autotrace for a user account?

972

Why is oracle database so popular?

947

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1891

What is a snapshot in oracle database?

971