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 purpose of a cluster?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
How to display the hierarchy of employee and managers without using connect by prior.
How can I introduce multiple conditions in like operator?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How to recover a dropped index?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?
What is TNS File
What is transport network substrate (tns) in oracle?
What is an UTL_FILE.What are different procedures and functions associated with it?
How to write date and time literals in oracle?