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

Compare and contrast between sql and sql server and explain its various functions?

935

Explain the different normalization forms?

1032

What are the original export and import utilities?

1096

How can we view last record added to a table?

988

What is the data pump export utility?

1040

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

2101

Differentiate between post-database commit and post-form commit?

995

Can a formula column referred to columns in higher group ?

2476

Can we commit inside a function in oracle?

936

What do you mean by merge in oracle and how can you merge two tables?

928

How to assign a tablespace to a users in oracle?

1013

What is the maximum limit on the number of columns in a table?

1044

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2238

How to compare dates in oracle sql?

1069

What happens in oracle commit?

985