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 to call a stored function in oracle?

1018

What is SQL access advisor in Oracle?

1191

How to convert character types to numeric types?

1134

Oracle

2377

Is oracle a language?

946

Explain constraining triggers.

1097

What is difference between sid and service name in oracle?

956

What privilege is needed for a user to connect to oracle server?

994

What are the four Oracle system processes that must always be up and running for the database to be useable?

1017

Explain the use of analyse option in exp command.

1128

What is a dead lock in oracle?

1122

How to execute a stored program unit?

1077

Give the advantages and disadvantages of clusters.

1050

What are the oracle built-in data types?

1074

When do you get a .pll extension in oracle? Explain its importance

1042