sql query to get zero records from a table

Answer Posted / vipul.solanki

select * from menu_master where rownum <1;

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to grant create session privilege to a user in oracle?

572


can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2597


Explain the difference between a procedure and a function? What do you understand by those terms?

624


What is meant by joins? List out the types of joins.

526


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1589






What is the use of file param in imp command?

644


How can I see all tables in oracle?

542


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

4668


Why is oracle so popular?

561


How can I convert single byte kana characters into multi byte kana characters and vice-versa.

1933


Point out the difference between user tables and data dictionary?

546


What is difference between truncate and delete?

561


What is a initialization parameter file in oracle?

584


What is an oracle?

579


How to count duplicated values in a column in oracle?

554