pro*c program for sql

user71408 · #1 (**permalink**) 03-26-2008

Hi all,
I have sql query as follows. Please write a pro*c program for the following query.

Code:

select
         sp1.cost_change
||','||  sp1.cost_change_desc
||','||  sp1.reason
||','||  to_char(sp1.active_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.status
||','||  sp1.cost_change_origin
||','||  to_char(sp1.create_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.create_id
||','||  to_char(sp1.approval_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.approval_id
from     supp_prods sp1
where    sp1.cost_change   in (select sp.cost_change
                                from   supp_stat     dcp,
                                         sup_detail     spd,
                                        sup_prd         sp
                                where  sp.active_date       = to_date('02-feb-2008 00:00:00','DD-MON-YYYY HH24:MI:SS')
                                and    sp.cost_change       = spd.cost_change
                                and    spd.item              = dcp.item
                                and    spd.supplier          = dcp.supplier
                                and     sp.origin_country_id = dcp.origin_country_id
                                and    sp.unit_cost         = dcp.unit_cost)

Can any one please help me to write the pro*c code for this.

Thank you.
Kris

iBot · #2 (**permalink**) 03-26-2008

Quote:

Originally Posted by user71408

Hi all,
I have sql query as follows. Please write a pro*c program for the following query.

Code:

select
         sp1.cost_change
||','||  sp1.cost_change_desc
||','||  sp1.reason
||','||  to_char(sp1.active_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.status
||','||  sp1.cost_change_origin
||','||  to_char(sp1.create_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.create_id
||','||  to_char(sp1.approval_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.approval_id
from     supp_prods sp1
where    sp1.cost_change   in (select sp.cost_change
                                from   supp_stat     dcp,
                                         sup_detail     spd,
                                        sup_prd         sp
                                where  sp.active_date       = to_date('02-feb-2008 00:00:00','DD-MON-YYYY HH24:MI:SS')
                                and    sp.cost_change       = spd.cost_change
                                and    spd.item              = dcp.item
                                and    spd.supplier          = dcp.supplier
                                and     sp.origin_country_id = dcp.origin_country_id
                                and    sp.unit_cost         = dcp.unit_cost)

Can any one please help me to write the pro*c code for this.

Thank you.
Kris

Hi there . Do not ask me any more questions please.
Wow you are very polite.

Count me out on this one, I was never much of a writer.In the context of allI have sql query as follows, I don't understand "select sp1."
Do you have any idea what I am talking about?
Do you prefer books or TV?
What kind of food do you like?
What do you do in your spare time?
Who are you talking about?
I lost my train of thought.
What do you look like?
What is your real name?
That input matched my default category.
Do you have any conditions I should know about?
By the way, do you mind if I ask you a personal question?
What you said was either too complex or too simple for me.
Do you prefer books or TV?
Do you have any conditions I should know about?
Is that your final answer?
What do you really want to ask me?
Do you still ?
What are you wearing?
I lost my train of thought.
What do you do in your spare time?
Try saying that with more or less context.
What are you wearing?
Do you like talking to me?
you are quite welcome.
I've lost the context, . Are we still on unit_costCan any one please help me to write the pro*c code for this?

pranabrana · #3 (**permalink**) 06-02-2008

Quote:

Originally Posted by user71408

Hi all,
I have sql query as follows. Please write a pro*c program for the following query.

Code:

select
         sp1.cost_change
||','||  sp1.cost_change_desc
||','||  sp1.reason
||','||  to_char(sp1.active_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.status
||','||  sp1.cost_change_origin
||','||  to_char(sp1.create_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.create_id
||','||  to_char(sp1.approval_date,'DD-MON-YYYY HH24:MI:SS')
||','||  sp1.approval_id
from     supp_prods sp1
where    sp1.cost_change   in (select sp.cost_change
                                from   supp_stat     dcp,
                                         sup_detail     spd,
                                        sup_prd         sp
                                where  sp.active_date       = to_date('02-feb-2008 00:00:00','DD-MON-YYYY HH24:MI:SS')
                                and    sp.cost_change       = spd.cost_change
                                and    spd.item              = dcp.item
                                and    spd.supplier          = dcp.supplier
                                and     sp.origin_country_id = dcp.origin_country_id
                                and    sp.unit_cost         = dcp.unit_cost)

Can any one please help me to write the pro*c code for this.

Thank you.
Kris

You can use EXEC SQL command before this code
example

EXEC SQL "select * from emp";

iBot · #4 (**permalink**) 06-02-2008

Quote:

Originally Posted by pranabrana

You can use EXEC SQL command before this code
example

EXEC SQL "select * from emp";

No I don't think I can do use EXEC SQL command before this codeexample EXEC SQL select * from emp;.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
A program to trace execution of another program	jiten_hegde	High Level Programming	3	08-19-2008 05:26 AM
How to write to stdin of another program (program A -> [stdin]program B)	vvaidyan	UNIX for Dummies Questions & Answers	3	08-02-2008 05:21 PM
How to write to stdin of another program (program A -> [stdin]program B)	vvaidyan	High Level Programming	1	04-30-2008 01:44 PM
executing a program within a program	Gekko	High Level Programming	4	06-27-2002 03:36 PM
ftp program	paost712	UNIX for Dummies Questions & Answers	3	01-06-2002 04:20 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by