Latest Answer: You should put your question here. This forum is not a library. Please take care. ...
Latest Answer: select * from (select rownum r, a.* from user_tab_columns a where table_name ='EMPLOYEE') where r=(select count(column_id) from user_tab_columns where table_name ='EMPLOYEE') ...
Latest Answer: No. You cannot export a higher version to the lower version. ...
What will the Output for this Coding> Declare Cursor c1 is select * from emp FORUPDATE; Z c1%rowtype;Begin Open C1;Fetch c1 into Z;Commit;Fetch c1 in to Z;end;
Latest Answer: Cursor Variable RestrictionsCursor variables are subject to the following restrictions; Oracle may remove some of these in future releases. Cursor variables cannot be declared in a package since they do not have a persistent state. You cannot use RPCs ...
Can we declare a column having number data type and its scale is larger than pricesionex: column_name NUMBER(10,100), column_name NUMBAER(10,-84)
Latest Answer: Alter table disable all trigger; ...
Latest Answer: You can use bulk binding to avoid cursors. It improves performance by minimizing context switches sql and pl/sql. When you are hadling large volume of data then better to use bulk binding. ...
How we can create a table in PL/SQL block. insert records into it??? is it possible by some procedure or function?? please give example...
Latest Answer: Its depend upon the query. If the two queries are firing on the table it is not possible. If the queries are firing on different different tables then it is possible.Thanks & RegardsMadhu D. ...
View page << Previous 10 11 12 13 [14] 15 16 17 18 19 Next >>
Go Top
