1:-How to write to update command in a procedure in oracle
which update two different table at a time
2:-How to write the select command in a procedure in oracle
which give multiple records
Answer / guneetinder singh
update query depends upon no. of column two tables contain.
declare
salary number:=&salary;
procedure guneet(s in number) as
begin
update emp set sal = sal+s;
update gesture set sal1 = sal1+s;
end guneet;
begin
guneet(salary);
end;
--------------------------------------------------------------
declare
procedure multiple() as
begin
select * from emp;
end multiple;
begin
guneet();
end;
Is This Answer Correct ? | 1 Yes | 7 No |
Display the records between two range?
What is hot backup and logical backup?
when loggined as SYSTEM,how to display all the users of database using sql query?
What is Hash Cluster ?
What is Partitions in Table ?
Can a formula column referred to columns in higher group ?
how many columns can a plsql table have
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
How to open and close an explicit cursor in oracle?
Explain the use of online redo log files in oracle.
How to create a table interactively?
Can group functions be used in the order by clause in oracle?