Home » Developer & Programmer » Precompilers, OCI & OCCI » Starter:To add sql commands in ProC.
Starter:To add sql commands in ProC. [message #94160] Thu, 08 April 2004 23:01 Go to next message
rajevani
Messages: 1
Registered: April 2004
Junior Member
hai,

I am a starter in ProC script, please guide me how to execute

update and insert commands in the Proc script.

 

regards,

rajevani

 

 
Re: Starter:To add sql commands in ProC. [message #94176 is a reply to message #94160] Thu, 15 April 2004 02:00 Go to previous message
Lalit Grover
Messages: 3
Registered: April 2004
Junior Member
Hi Rajevani

EXEC SQL INSERT INTO EMP (NAME, AGE) VALUES('NEWEMP',20);

EXEC SQL UPDATE EMP
SET NAME = 'NEWEMP'
WHERE AGE = 20;

Regards,
Lalit Grover
Previous Topic: Want to Create Text File in Pro*C having data stored in oracle Table
Next Topic: steps in compiling and running an embedded c program
Goto Forum:
  


Current Time: Thu Mar 28 16:11:12 CDT 2024