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

 

 

Report message to a moderator

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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 07 03:31:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.