Home » SQL & PL/SQL » SQL & PL/SQL » How to manipulate and insert records from flat fil???
icon4.gif  How to manipulate and insert records from flat fil??? [message #186702] Wed, 09 August 2006 02:41 Go to next message
loveoracle
Messages: 41
Registered: February 2006
Location: Mumbai
Member


Dear All,
I have one flat file like:

ID	name		q1	q2	q3	q4
1245	vjda dkda	1	33	2	"won,lost,yet to be decided"
2334	djd ajdjs	0	2	1	gain
2255	dkj fjdjd	1	1	32	loss
7674	dkfj dkjfj	1	34	1	in 
8853	dkf fjffds	0	56	0	still not known

In PL/SQL block I want to insert that data into table, but before inserting we have to manipulate that data.
If anybody done this successfully then please tell me.

Thanks in advance.


Re: How to manipulate and insert records from flat fil??? [message #186714 is a reply to message #186702] Wed, 09 August 2006 03:38 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use external tables.
Re: How to manipulate and insert records from flat fil??? [message #186717 is a reply to message #186714] Wed, 09 August 2006 03:49 Go to previous messageGo to next message
loveoracle
Messages: 41
Registered: February 2006
Location: Mumbai
Member

Can u give me Idea about it?
Re: How to manipulate and insert records from flat fil??? [message #186721 is a reply to message #186717] Wed, 09 August 2006 04:17 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes, read documentation about the whole concept; can be found in the sticky thread or Oracle Technology Network.

Shortly, when you have a file, Oracle can access it just as if it was an ordinary Oracle table - you can write queries on it, manipulate data etc. - quite flexible, especially when compared to SQL*Loader.
Re: How to manipulate and insert records from flat fil??? [message #186879 is a reply to message #186702] Thu, 10 August 2006 00:35 Go to previous message
loveoracle
Messages: 41
Registered: February 2006
Location: Mumbai
Member

Thanks for ur useful feedback.
Now I am closing this thread.
Previous Topic: Can I sort value in array ?
Next Topic: using nested table in a package ...
Goto Forum:
  


Current Time: Mon Dec 05 14:56:58 CST 2016

Total time taken to generate the page: 0.10852 seconds