Home » SQL & PL/SQL » SQL & PL/SQL » how can i make a table
icon4.gif  how can i make a table [message #190496] Thu, 31 August 2006 01:38 Go to next message
sabrieker
Messages: 8
Registered: August 2006
Location: turket
Junior Member
hello i have a data in abc.txt
and i want to take datas from txt file into a table
i tried like this one
create table abc_source select * from migros_source
but as u know didnt work how i can create a table quickly
Re: how can i make a table [message #190497 is a reply to message #190496] Thu, 31 August 2006 01:42 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,


 use external table or sqlloader.




regards,
Re: how can i make a table [message #190510 is a reply to message #190496] Thu, 31 August 2006 02:26 Go to previous messageGo to next message
sabrieker
Messages: 8
Registered: August 2006
Location: turket
Junior Member
upps thanks for attachment but how can i do i dont know can i use data import??
Re: how can i make a table [message #190529 is a reply to message #190496] Thu, 31 August 2006 03:29 Go to previous message
sabrieker
Messages: 8
Registered: August 2006
Location: turket
Junior Member
thanx again i have a small problem that is txt source has 2 more column so i couldnt do
thanx again relation for this
Previous Topic: how to check return status and write to the log file?
Next Topic: BitMap Index
Goto Forum:
  


Current Time: Sun Dec 04 23:13:07 CST 2016

Total time taken to generate the page: 0.14017 seconds