Home » SQL & PL/SQL » SQL & PL/SQL » Need help with pl/sql (9i)
Need help with pl/sql [message #328961] Mon, 23 June 2008 10:05 Go to next message
dalavai
Messages: 3
Registered: June 2008
Location: hyderabad
Junior Member

Hello ,

heres a small problem to solve. here it is briefly... please help me


we have an external file will 6000 columns.

as we know 1000 columns are limited per table.
we need to split it into 1000 columns or what ever you wish.
and here comes another problem we know that the size limit for external file is 2GB.

and we need to retrive all the data at once.

please help me

cherrie.
Re: Need help with pl/sql [message #328964 is a reply to message #328961] Mon, 23 June 2008 10:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Write your own program if you encounter these limits or upgrade to a newer version.

By the way, if you have table with more than 1000 (or even 200 columns) then you likely have a design problem without speaking about the peformances you will have.

Regards
Michel

[Updated on: Mon, 23 June 2008 10:15]

Report message to a moderator

Re: Need help with pl/sql [message #328966 is a reply to message #328964] Mon, 23 June 2008 10:25 Go to previous messageGo to next message
dalavai
Messages: 3
Registered: June 2008
Location: hyderabad
Junior Member
can you please tell me the logic.
Re: Need help with pl/sql [message #328968 is a reply to message #328966] Mon, 23 June 2008 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The logic about what?

Regards
Michel
Re: Need help with pl/sql [message #328970 is a reply to message #328968] Mon, 23 June 2008 10:30 Go to previous messageGo to next message
dalavai
Messages: 3
Registered: June 2008
Location: hyderabad
Junior Member
Logic to create that programs. I am really sorry to say that i am a dumb guy in pl/sql
Re: Need help with pl/sql [message #328973 is a reply to message #328961] Mon, 23 June 2008 10:34 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>we need to retrive all the data at once.
What does this mean?

What would you like done with the 6000 rows of data?

Why is this problem restricted to be solved with PL/SQL?
Re: Need help with pl/sql [message #328986 is a reply to message #328970] Mon, 23 June 2008 11:57 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
I think this is the third instance where I am seeing when people cross post between forums then tend to cut short the original message. I don't understand why.

Check the following links for a brief explanation/discussion on the following topic.

http://forums.oracle.com/forums/thread.jspa?threadID=672009

Regards

Raj

[Edit] Fixed the Url

[Updated on: Mon, 23 June 2008 11:58]

Report message to a moderator

Previous Topic: Encountered : Ora 29259 while capturing emails from a Google POP server
Next Topic: Insert statement from web apps resulted multiple records inserted into database problem
Goto Forum:
  


Current Time: Sat Dec 10 05:11:23 CST 2016

Total time taken to generate the page: 0.10173 seconds