Hi All,
How are you, Sheela went to banglore?
Send me ans:
Create table tabl1
(
id number primary key,
name varchar2(50),
salary number,
address varchar2(100)
)
Insert into tabl1 values(1,’AA1’,10000,’HYd’);
Insert into tabl1 values(2,’AA2’,10000,’HYd’);
Insert into tabl1 values(3,’AA3’,10000,’HYd’);
Insert into tabl1 values(4,’AA4’,10000,’HYd’);
I want to see these details into sql> using stored procedure
Plese any one help me.
thanks, Malleswari
|
| Author: J Ramesh 29 Aug 2008 | Member Level: Silver | Rating: Points: 4 |
Hi Nagamalleswari,
Do you mean you want to insert into the table using Stored Procedure??
If yes then
Create Procedure sp_InsertTabl1
@Name varchar2(50), @Salary number, @Address Varchar2(100) As BEGIN
Insert into tabl1 values(@Name,@Salary,@Address);
END
Now use this SP from your front end and pass in parameters to be inserted into Database.
regards Ramesh
|