pro*c program for sql Post: 302201596

Sponsored Content

The Lounge What is on Your Mind? Chat with iBot - Our RSS Robot Girl pro*c program for sql Post 302201596 by pranabrana on Monday 2nd of June 2008 03:12:38 PM

06-02-2008

Registered User

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";

pranabrana

View Public Profile for pranabrana

Find all posts by pranabrana

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pro*c program for sql query

Hi all, I have sql query as follows. Please write a pro*c program for the following query. 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...

2. Shell Programming and Scripting

Still unable to compile pro*c program

I am unable to compile the programs, I am able to compile .pc to .c but later part of the compilation from .c to executalbe i am unable to do. Here is the way i am doing make -f $LIB_LIB/makefile.templ sample I am getting the following errors, which environment and where to set to point...

3. UNIX for Dummies Questions & Answers

PRo*C program for SQL queries using threading concept

Hi All, I have written 4 SQL queries. I want to write PRO*C program for this. I want to put these 4 queries in a single PR*C program using threading concept. Please guide me to write the pogram. the queries are as follows. 1. select * from head; 2. select * from details; 3. delete from head...

4. Programming

problem with sql command in pro*c

In a pro*C program, I use query follow: INSERT INTO radacct_wk SELECT (select psid from cscterminfo where cscterminfo.TELNO = username), nasipaddress, acctstarttime, acctstoptime, acctsessiontime, acctinputoctets, acctoutputoctets, acctterminatecause, framedipaddress FROM radacct@DBSV_B;...

5. Programming

Compiling Pro*C program under unix

Hello, I am trying to compile a Pro*C program under unix: proc iname=test.pc works fine but then I am not able to compile the test.c file : gcc test.c -o test.o -L $ORACLE_HOME/lib -l clntsh /usr/bin/ld: Object file format error in: /u01/app/oracle/product/10.1.0.2.0/lib:...

6. Programming

Do pro*c program need to recompile

hi, I have pro*c program running on sunsolaris 5.9.Currently the same program has been migrated to solaris 5.10.But the program is not giving the desired output.Do i need to recomplie the source code again. Regards, Megh

7. Solaris

Issue in pro*C program compiled in solaris 10

Hi, We upgraded our servers from solaris 9 to 10. We recompiled all the Pro*C programs with the new oracle version as well. Oracle is 11g. We are facing core dump with the below error for certain executions. But when we are placing new statements between the error fucntion we get junk values to...

8. Programming

Decript a File Generated by a Pro*C Program

Hi, I've a Pro*C program that generates a file with dat extension and it uses the following function to encrypt the data in the file. Can anyone help in creating a function/program in any language that can decrypt the dat file? void encrypt (unsigned long* entryvar) { typedef struct{...

9. Programming

Sql Procedure in Pro C file

Hi, Can any one help me how to write a sql procedure in a pro *c file for selecting the data from a database and inserting the rows into a queue in a .pc file. thanx in advance.

10. Shell Programming and Scripting

awk script to parse SQL from Pro*C program

Hello, I have a Pro*C program which contains SQL sentences, such as: .... Pro*C sentences .... /*SQL 1*/ EXEC SQL SELECT t1.field1, t1.field2 INTO :w_field FROM TABLE1 t1, TABLE1 t2 WHERE t1.field1 = t2.field1 AND t1.ID = :wl_id; .... Pro*C sentences .... /*SQL 1*/ EXEC...

LEARN ABOUT DEBIAN

swac-get

SWAC-GET(1)						      General Commands Manual						       SWAC-GET(1)

NAME

       swac-get - audio collections of words (SWAC) manager

SYNOPSIS

       swac-get [-t] [clear] [update] | [upgrade] | [select <url|packid>] | [deselect <url|packid>] | [list] | [list-sources] | [list-available] |
	       [sql <query>] | [--help] | [--version]

DESCRIPTION

       Swac-get is a simple command line program which allows to download and install audio collections of words (SWAC)  in  a	SQLite3  database.
       Audio  collections  can	be imported from the hard drive or directly from the Internet using the HTTP protocol.	Swac-get is designed to be
       used with swac-explore, a GTK+ interface which allows the browsing of the created SQLite3 database.  An important set of free audio collec-
       tions of words (SWAC) is available at: http://swac-collections.org/

       For more information, please, visit the Shtooka Project homepage at: http://shtooka.net/ .

COMMANDS

       clear  clear database

       deselect <url|packid>
	      delete records of the package <url|packid> from the database

       list   list installed packages

       list-available
	      list available packages

       list-sources
	      list source repositories

       sql <query>
	      execute a sql query in the database

       select <url|packid>
	      insert records of the package <url|packid> in the database

	      ex: swac-get select file:///home/<my directory>/
		  swac-get select http://packs.shtooka.net/<my package>/ogg/
		  swac-get select fra-balm-voc

       select source-delete <url>
	      delete <url> from the repositories list

       source-deselect <url>
	      deselect <url> from the repositories list

       source-select <url>
	      add <url> to the repositories list

	      ex: swac-get source-select http://packs.shtooka.net/
		  swac-get source-select file:///home/<my directory>/

       update update the list of available packages

       upgrade
	      upgrade installed packages

OPTIONS

       -t, --target <path>
	      set the SQLite3 database path (default path is ~/.swac/swac.db)

       -v, --version
	      print version information and exit

       -h, --help
	      print this help and exit

EXAMPLES

       swac-get source-select http://packs.shtooka.net/

       swac-get update

       swac-get select chi-balm-hsk1

       swac-get select fra-balm-voc

BUGS

       swac-get doesn't care about the version number for the upgrade command.

AUTHOR

       swac-get and this manual page were written by Nicolas Vion <nico@picapo.net>.

								   mai 25, 2008 						       SWAC-GET(1)