How to export the Query and Results in Oracle SQL *Plus Worksheet

No.of Views	:	767
Bookmarked	:	0 times
Downloads	:
Votes	:	0

By youngmurukan On 15 Feb 2010 21:02:15

Tag : Oracle , How to

Skill Level: Intermediate

Images in this article missing? We recently lost them in a site migration. We're working to restore these as you read this. Should you need an image in an emergency, please contact us at info@codegain.com

In oracle SQL *Plus Worksheet you can simply export the query and results to external files rather copy and paste.

E.g :If you want to export the all employee details to Text file, Here it is the very simple solution ;

Spool c:\Employees_Data.txt;

Select * From Employees ;

Once you run this query,The Query and Results would export to Employees_Data.txt file.

About Author

youngmurukan

Occupation	-	Not Provided
Company	-	Not Provided
Member Type	-	Senior
Location	-	Not Provided
Joined date	-	12 May 2009
Home Page	-	Not Provided
Blog Page	-	Not Provided


Other popularSectionarticles
ORACLE-The differences of VARCHAR2 (5) and VARCHAR2 (5 byte) ORACLE-The differences of VARCHAR2 (5) and VARCHAR2 (5 byte) Published Date : 15/Feb/2010 ORACLE - UNIQUE Constraints and NULL Values ORACLE - UNIQUE Constraints and NULL Values Published Date : 15/Feb/2010 Autonomous Transactions in Oracle Autonomous Transactions in Oracle Published Date : 15/Feb/2010 How to get Running Total in Oracle How to get Running Total in Oracle Published Date : 15/Feb/2010 Use of SOUNDEX() Function in Oracle Use of SOUNDEX() Function in Oracle Published Date : 15/Feb/2010

Comments

There is no comments for this articles.