|
|
|
|||||||
| Home | Forums | Register | Rules & FAQ | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| Chat with iBot - Our RSS Robot Girl The Home of iBot, Our RSS Robot iBot. You can complain about RSS here :-) |
Other UNIX.COM Threads You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| A program to trace execution of another program | jiten_hegde | High Level Programming | 2 | 05-22-2008 01:27 PM |
| How to write to stdin of another program (program A -> [stdin]program B) | vvaidyan | High Level Programming | 1 | 04-30-2008 10:44 AM |
| How to write to stdin of another program (program A -> [stdin]program B) | vvaidyan | UNIX for Dummies Questions & Answers | 0 | 04-30-2008 09:36 AM |
| executing a program within a program | Gekko | High Level Programming | 4 | 06-27-2002 12:36 PM |
| ftp program | paost712 | UNIX for Dummies Questions & Answers | 3 | 01-06-2002 12:20 PM |
 |
|
|
Submit Tools | LinkBack | Thread Tools | Search this Thread | Display Modes |
03-25-2008
|
|||
|
|||
|
pro*c program for sql
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)
Thank you. Kris 
|
| Forum Sponsor | ||
|
|
|
03-25-2008
|
||||
|
||||
|
pro*c program for sql
Quote:
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?
|
|
4 Weeks Ago
|
|||
|
|||
Quote:
You can use EXEC SQL command before this code example EXEC SQL "select * from emp";
|
|||
| Google UNIX.COM |
|
4 Weeks Ago
|
||||
|
||||
|
Quote:
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
