Oracle Sql Lo Oka Bacha Question

[juvenile]

Oracle IN list lo values ni oka file dwara pass cheyocha?

naa requirement .. oka file lo 1000 values unnai .. i need to run a SQL to get data from table matches columnID -> data in file

[CheGuevara]

ardamkale

[KOTC]

[quote name='CheGuevara' timestamp='1370286990' post='1303818700']
ardamkale
[/quote]
+1

[juvenile]

[quote name='CheGuevara' timestamp='1370286990' post='1303818700']
ardamkale
[/quote]
[quote name='STFU' timestamp='1370287028' post='1303818703']
+1
[/quote]

Example .. Naa SQL IDI

select JOBNAME,STATUS from XXXX where JOBNAME in (a,b,c,d)

i have a text file with JOBNAMEs .. so a,b,c,d kakunda Job names ee file nunchi read chesukunetlu cheyochaaaaa

[CheGuevara]

[quote name='AggiRamudu' timestamp='1370287296' post='1303818723']
Example .. Naa SQL IDI

select JOBNAME,STATUS from XXXX where JOBNAME in (a,b,c,d)

i have a text file with JOBNAMEs .. so a,b,c,d kakunda Job names ee file nunchi read chesukunetlu cheyochaaaaa
[/quote]


atla cheyyadam telidu kani....

ade file lo values tho table create cheste saripoye ....adi easy kada

[150bryant]

[quote name='CheGuevara' timestamp='1370287630' post='1303818745']


atla cheyyadam telidu kani....

ade file lo values tho table create cheste saripoye ....adi easy kada
[/quote]
agreed. but files unaye kadha...malli table creation antey extra effort kadha

[CheGuevara]

[quote name='BathiBottleBisket' timestamp='1370287802' post='1303818762']
agreed. but files unaye kadha...malli table creation antey extra effort kadha
[/quote]


use external tables.....


check this thread



https://forums.oracle.com/forums/thread.jspa?threadID=2159602

[juvenile]

[url="https://forums.oracle.com/forums/thread.jspa?threadID=2344082"]https://forums.oracle.com/forums/thread.jspa?threadID=2344082[/url]