How did you export data from database to excel file.






How did you export data from database to excel file...

Answer / rocker

Select the table from which the want to extract data. Right click on table >> Task >> Export Data and select the data source and target table and export data.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer




More SQL PLSQL Interview Questions

what is sql optimization

1 Answers   Fidelity,


In a distributed database system, can we execute two queries simultaneously?

0 Answers  


What is multiple columns?

0 Answers  


how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,


how to findout the 100th maximum salary

28 Answers   Amdocs,






What are the modes of parameters that can be passed to a procedure ?

3 Answers  


i don't want the message as 14 rows updated just it should update what it will do

4 Answers  


I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,


Explain what is an index?

0 Answers  


what is try_catch block in procedure

0 Answers  


what does the t-sql command ident_incr does? : Transact sql

0 Answers  


How to find only %th Highest Sal

6 Answers   Symphony, Infogain,






Categories