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|
what is sql optimization
In a distributed database system, can we execute two queries simultaneously?
What is multiple columns?
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);
how to findout the 100th maximum salary
What are the modes of parameters that can be passed to a procedure ?
i don't want the message as 14 rows updated just it should update what it will do
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
Explain what is an index?
what is try_catch block in procedure
what does the t-sql command ident_incr does? : Transact sql
How to find only %th Highest Sal