Home » SQL & PL/SQL » SQL & PL/SQL » How to change the format
icon5.gif  How to change the format [message #278234] Fri, 02 November 2007 08:06 Go to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
hi all,

After I ran this script i got this format

 Log1.Txt
---Nedfleet card 1
select 'Foreign key check with ASSETS VEHICLE file' from dual
union
select k.CRD_ASSET_REGN_NO from omf_api_nedfleet k
minus
select q.ase_registration_nbr from omf_api_asset_vehicle q
/
spool off


After run this i got this format..

'FOREIGNKEYCHECKWITHASSETSVEHICLEFIL                                            
------------------------------------                                            
ForeignkeycheckwithASSETSVEHICLEfile

I need to get this format
'FOREIGN KEY CHECK WITH ASSETS VEHICLE FILE'...PLEASE HELP ME OUT
Re: How to change the format [message #278236 is a reply to message #278234] Fri, 02 November 2007 08:15 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Have a look at this.

By
Vamsi
Previous Topic: Problem with bulk collect limit
Next Topic: Why DML operation cannot be performed inside query---ora:14451
Goto Forum:
  


Current Time: Wed Dec 07 06:50:48 CST 2016

Total time taken to generate the page: 0.18721 seconds