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 |
What is the difference between 10g OEM and 11g OEM?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
what is the scripts in data base?
What is the order of defining local variables and sub procedures/functions?
What is using clause and give example?
Differentiate between translate and replace?
where we have to use ON clause and where we have to use USING clause in JOINS
What is the string concatenation operator in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
Describe an oracle table?
What is a proxy object?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.