I want to write data from table to flat file this is possible through pl/sql how ? -

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

DATABASE

DETAILS

Question: I want to write data from table to flat file this is possible through pl/sql how ?

Answer:

Category	Database Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 6961 users
Added on	5/20/2013
Views	71472
Rate it!

Question: I want to write data from table to flat file this is possible through pl/sql how ?

Answer:

Source: CoolInterview.com

using utl_file packages we can do this.
Source: CoolInterview.com

Answered by: sowmyakmf | Date: 8/31/2008 |

Contact sowmyakmf

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	If i have unique key this is possible to create another unique key on table .	View Answer
	If i have primary key this is possible to create another primary key on table.	View Answer
	What is primary & unique key which type index oracle create when we make those key ?	View Answer
	What is view is it possible to create index on view on view & how ?	View Answer
	What is row changing how u eliminate ?	View Answer
	How we determine index require rebuilding ?	View Answer
	How we determine index require rebuilding ?	View Answer
	Your query return 80 % data from table is it we use index or not why ?	View Answer
	How you can determine query use full table scan?	View Answer
	I don't set user dump test parameter where trace file default store on linux platform.	View Answer
	where is trace file generate & when this is create .	View Answer
	How you implement trace of query when user run query what is syntax ?	View Answer
	If a user complaint his query run slow how u detre mine which is reason ?	View Answer
	Which files of unix or linux use or configure in oracle installation ?	View Answer
	If i create unquie index on empid of employees table which index i create bitmap or btree why ?	View Answer
	How data store in bitmap & btree index what is benefit ?	View Answer
	what type of indexes?	View Answer
	How sga use if i execute select * from emp where empid=111;	View Answer
	Is it possible we can define the path of control file backup by creating a text tarce file default where this is store ?	View Answer
	Why are we not use tablespce begin backup with read only tablespace?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Database Interview Questions & Answers - Exam Mode / Learning Mode