select * from menu_master where rownum <1;

sql query to get zero records from a table

Question Posted / vipul.solanki

Answer Posted / vipul.solanki

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2332

How to create lov dynamically at runtime & attach to text field?

1238

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2233

How to start a specific oracle instance?

1079

Can we convert a date to char in oracle and if so, what would be the syntax?

1062

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

1056

How to update values on multiple rows in oracle?

1074

6. Display the client name and order date for all orders using the traditional method.

2354

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

1033

What is a directory object?

1136

What is clustered table in Oracle?

1258

How to convert csv to table in oracle?

1043

What is the dynamic sql in oracle?

1130

What is the difference between hot backup and cold backup in oracle?

1076

How do you tell what your machine name is and what is its IP address?

2156