select * from tab;

How to get a list of all tables in the database?

Question Posted / tr

Answer Posted / tr

select * from tab;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Whether any commands are used for months calculation? If so, what are they?

1049

What do you mean by a tablespace?

992

How to get a create statement for an existing table?

922

What is the difference between truncate & delete command?

1141

How to create an initialization parameter file?

997

What is the max number of columns in an oracle table?

946

What is the implicit cursor in oracle?

1050

What privilege is needed for a user to query tables in another schema?

934

What do you mean by group by clause?

993

Is there a combination of "like" and "in" in sql?

1016

How to resolve the ORA-39133 error in Oracle?

1051

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

978

How to get maxsal , minsal, ename department wise in single query

1508

How to update a table row with a record?

972

What is archive log in Oracle?

1082