sql query to get zero records from a table having n no of
records
- 8 Answers
- 23280 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / giri
Select * From Table_Name Where 1 = 2;
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is a sql*loader control file?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
How exception handling is done in advance pl/sql?
How do I restart sql?
Is sql procedural language?
How do I add a primary key to a table?
How do I write a cron which will run a sql query and mail the results to agroup?
What is number function in sql?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
Explain how can you save or place your msg in a table?
What are the types of queries in sql?
What is sql and how does it work?
what is sql server agent? : Sql dba
how to shutdown mysql server? : Sql dba
What are the advantages of sql? Explain
