Home » SQL & PL/SQL » SQL & PL/SQL » Selecting from a XLS file (merged)
Selecting from a XLS file (merged) [message #266157] Mon, 10 September 2007 01:06 Go to next message
sonalshastry
Messages: 52
Registered: September 2007
Member
How can I retrieve data in a single PLSQL query for 14000
distinct clients at a time except creating temp table for 14000 client

please help

sonal

[Updated on: Mon, 10 September 2007 02:57]

Report message to a moderator

Re: please help [message #266159 is a reply to message #266157] Mon, 10 September 2007 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Please always post your Oracle version (4 decimals).
Please give a USEFUL and MEANINGFUL title.

Remember this is Oracle forum.

Regards
Michel
Re: please help [message #266177 is a reply to message #266157] Mon, 10 September 2007 01:53 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
sonalshastry wrote on Mon, 10 September 2007 01:06

How can I retrieve data in a single PLSQL query for 14000
distinct clients
at a time except creating temp table for 14000 client

please help

sonal




Use Cursor
Re: please help [message #266200 is a reply to message #266177] Mon, 10 September 2007 03:23 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
What I REALLY wonder is whether he is talking about 14000 'data' clients that are stored in the database, or if he is talking about 14000 'database' clients that want the same data. ./fa/1600/0/

It seems today is one of those "vague question" days again.
icon1.gif  Conditional Select qurey [message #266201 is a reply to message #266157] Mon, 10 September 2007 03:28 Go to previous messageGo to next message
sonalshastry
Messages: 52
Registered: September 2007
Member
I have a table having client details
now I want to retrive the contact detailds from this table
client id is primary key
but the client list for which data is required is in a .XLS file & the list is of 14000 client

how can I retrive data in a single PLSQL qurey
I want to put that clients in where clause
qurey is as follws



[PLSQL]
SELECT E.CLIENT_ID, E.CLIENT_MOBILE_NO,
E.CLIENT_PHONE_NO_1, E.CLIENT_PHONE_NO_2

FROM ENTITY_MASTER E
WHERE E.CLIENT_ID IN ()








Re: Conditional Select qurey [message #266204 is a reply to message #266201] Mon, 10 September 2007 03:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The easiest way is to unload your XLS file into a CSV one and query it through an external table.

Regards
Michel
Re: please help [message #266211 is a reply to message #266200] Mon, 10 September 2007 03:58 Go to previous messageGo to next message
sonalshastry
Messages: 52
Registered: September 2007
Member
hi

database is one only
data rows in table is more than 300000
i want selective 14000 client datarows

thank you
sonal

Re: Conditional Select qurey [message #266213 is a reply to message #266204] Mon, 10 September 2007 04:00 Go to previous messageGo to next message
sonalshastry
Messages: 52
Registered: September 2007
Member
hi
i don't have rights to create a temp table
plz advice some thing else

sonal
Re: Conditional Select qurey [message #266216 is a reply to message #266213] Mon, 10 September 2007 04:01 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not a temp table, it is an external table. Nothing is store in the database (except table definition).

Regards
Michel
Previous Topic: whats the maximum columns in oracle 9i
Next Topic: Copy table with index.
Goto Forum:
  


Current Time: Thu Dec 08 12:32:42 CST 2016

Total time taken to generate the page: 0.23728 seconds