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

How translate command is different from replace?

548

How to drop an existing table in oracle?

593

What is a user account in oracle?

629

What is the difference between translate and replace in oracle?

656

What are the benefits of ordbms?

619

How to display row numbers with the records?

588

How many file formats are supported to export data?

659

What is null value in oracle?

638

How to use "in out" parameter properly?

614

What is raw datatype?

595

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1558

What is tns entry?

623

How many types of segments in Oracle?

531

What is query image?

586

Can group functions be mixed with non-group selection fields?

536