OraFAQ Forum: Server Administration » Re: Urgent! Select to file

Home » RDBMS Server » Server Administration » Re: Urgent! Select to file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Urgent! Select to file [message #373021]

Fri, 23 March 2001 07:13

Laert
Messages: 20
Registered: January 2000

Junior Member

Hi,

There is no way to send all records at once, without cursor?

Thank You
Laert

Report message to a moderator

Re: Urgent! Select to file [message #373022 is a reply to message #373021]

Fri, 23 March 2001 08:38

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi,

When you say select there is always a cursor involved. Whether its implicit or explicit is the question. And you are right... implicit are faster.

Try to use SQLJ or PROC(emedding sql directly into java or c) in this fashion you can use java or C array to fetch more records and keep it
in a array and write it to a file.

Bala.

Report message to a moderator

Re: Urgent! Select to file [message #373056 is a reply to message #373021]

Sat, 24 March 2001 04:39

Arjun V
Messages: 14
Registered: March 2001

Junior Member

Use triggers.

Arjun

Report message to a moderator

Previous Topic:	SQLPLUS/SQLLOader error handling/return codes
Next Topic:	Urgent! Select to file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 05:56:10 CST 2024