Oracle ODBC connectivity - Explain how to get Oracle data into MS-Excel posted
by Babu Kunwar
Explain how to get Oracle data into MS-Excel
There are many techniques for doing this. I will present one non-programming
technique. Just one thing we need is SQL Developer tool. SQL Developer is a
tool which is used for querying Oracle database. This tool provides an option
to export the data from Oracle table objects to CSV file format. CSV file
format stands for comma separated file. When you query the database through SQL
Developer as:
For example we execute a query as: SELECT * from table_name where column_name=’
’;
SQL developer fetches data from the database the one thing that you need to do
is just right click on the fetched data and click on the export link below and
then select the Excel sheet format the whole of that entity data will be
exported to Excel.
More links
What is a Trigger? Syntax of Triggers
Types of PL/SQL Triggers
How to obtain information about any trigger?
What is CYCLIC CASCADING in a TRIGGER?............ .
|
