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

what is the syntax of SELECT command?

Question Posted / poovitha

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

Please Help Members By Posting Answers For Below Questions

Can a formula column referred to columns in higher group ?

2498

What are the uses of a database trigger?

991

What is key preserved table?

1013

How to define an oracle sub procedure?

1136

How do I recompile a procedure in oracle?

958

What are the restrictions on external table columns?

1052

What are the differences between char and varchar2 in oracle?

1162

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4519

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

2130

What is flashback in Oracle?

1015

What do you mean by merge in oracle?

993

Explain overloading. Can functions be overloaded?

978

How to test null values?

1098

How to connect asp pages to oracle servers?

1069

Explain the use of indexes option in imp command.

1171