sql help

[kamapisaachi]

ee query lo pid value one value at a time etla pass cheyyali ? pid values are stored in another table called table b.

 

example

select * from table a

where pid = 2

inko loop iteration lo

select * from table b

where pid = 3

itla 100-200 times pid value marusthu query run cheyyali. output will be exported to multiple text files.

 

[Raazu]

6 minutes ago, kamapisaachi said:

ee query lo pid value one value at a time etla pass cheyyali ? pid values are stored in another table called table b.

 

example

select * from table a

where pid = 2

inko loop iteration lo

select * from table b

where pid = 3

itla 100-200 times pid value marusthu query run cheyyali. output will be exported to multiple text files.

 

Cursor

[chandrabhai7]

No clarity in question

[naughty15]

why one at a time?

if ur use case is one at time, then cursor.

[Tenali]

code it in shell script.. 

step 1) Output pid values to be iterated into a text file... create multiple files accordingly if it requires nested looping.

step 2) Use for loop to loop through all pid values from the text files..  redirect the output for every run into flat file according to your requirement.

[iTeachSAP]

7 hours ago, kamapisaachi said:

ee query lo pid value one value at a time etla pass cheyyali ? pid values are stored in another table called table b.

 

example

select * from table a

where pid = 2

inko loop iteration lo

select * from table b

where pid = 3

itla 100-200 times pid value marusthu query run cheyyali. output will be exported to multiple text files.

 

 

Ni daggara linux environment undha? Or python undha? SQL lo ante stored procs lo rayali. Atleast what database ee chepou.

[Googlie]

declare

cursor c_pid as 

select distinct pid from table b;

P_output_value varchar2(1000);

Begin

For x in c_pid 

loop 

select output_value

into p_output_value 

from table a where a.<pid_foriegn_key> = x.pid;

dbms_output.print_line(‘value of pid is: ‘ || p_output_value); 

End loop; 

end; 

 

[Googlie]

4 minutes ago, Googlie said:

declare

cursor c_pid as 

select distinct pid from table b;

P_output_value varchar2(1000);

Begin

For x in c_pid 

loop 

select output_value

into p_output_value 

from table a where a.<pid_foriegn_key> = x.pid;

dbms_output.print_line(‘value of pid is: ‘ || p_output_value); 

End loop; 

end; 

 

This is code for oracle database 

You can run in sql developer 

it prints the pid value in output window 

 

but if u need to write to a file then you can use a file function like fnd_file or a shell script etc