Home » RDBMS Server » Server Utilities » Can we use if to write control file
Can we use if to write control file [message #73398] Thu, 15 April 2004 05:45 Go to next message
Bharath Kumar V
Messages: 4
Registered: April 2004
Junior Member
Hi,

   Can we use if condition to develop a contol file in SQL Loader.If yes can i know what is the syntax and an example.

 

Thanks & Rgds

Bharath

Report message to a moderator

Re: Can we use if to write control file [message #73401 is a reply to message #73398] Fri, 16 April 2004 05:27 Go to previous message
Frank Naude
Messages: 4580
Registered: April 1998
Senior Member
Hi,

Yes, look at the WHEN clause. This is documented in the Oracle Utilities Users Guide. Also see http://www.orafaq.com/faqloadr.htm#SELECTIVE

Best regards.

Frank

Report message to a moderator

Previous Topic: i want to create a user which can not change his password, by using alter command. with the permissi
Next Topic: Export from RDB import to 9i NT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 16:36:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.