Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 5001 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is the database name in oracle?
What are the different editions of oracle?
What is oracle latest version?
Please explain joins in oracle?
What is catalog in Oracle?
When do I need to use a semicolon vs a slash in oracle sql?
What are the system predefined user roles?
What is the difference between pre-select and pre-query?
How to pass a cursor variable to a procedure?
Explain what are the different type of segments?
In which language oracle has been developed?
How do I recompile a procedure in oracle?
How to rename an existing table?
What are the components of logical database structure in oracle database?
