How will you debug PL/SQL Code?
Latest Answer: The Best way to debug is by using an AUTONOMOUS TRANSACTION. Create a dummy table and insert into the table using the AT. This wont affect the main code, but one could know which part of the code the execution has reached while the program is ...
How to fill a refcursor with dataset in C#.i want to pass a dataset as parameter and fill a refcursor with the same dataset.
Latest Answer: you need to use ODP.Net connector.In OracleCommand object add OracleParameter object with following propertiesOracleDbType = OracleDbType.RefCursor;Direction= ParameterDirection.Output;give the name of your stored procedures's refcursor parameter ...
what is the maximum size of the message that we can give in dbms_output.putline();
Latest Answer: The maximum size of package is 32kWe can't give  more than that ...
Mean I heard from Oracle 8i onwards the order of where clause condition does not matter which oracle creates the explain plan...and execute..Is it true?
Latest Answer: Yes the order is important. But it is important for the performance of the query and not for the final result. The output of the query will be the same irrespective of the order in which the join conditions are applied. Ideally the condition that filters ...
Latest Answer: 1. By default you cannot add not null constraints, which already have null value in the column.2. You need replace some dummy values to null value to meet requirement and then add constraint to that column. ...
Latest Answer: Flashback query is used to retrieve data, which is errantly deleted or updated in the database. Or we can say, we can see data prior to commit the data in the database.Flashback only available in system managed undo database.There are two method to retrieve ...
Write a PL/SQL fuction named say TRUN, which does the same work as the oracle predefined function "TRUNCATE".
Latest Answer: It will truncate/delete all the rows in the table emp very fast as compared of delete command, but the table must have no Foriegn keyMr. Ajaz Ahmad Kumar ...
what is the rollforward in pl/sql
Latest Answer: Rollforward is to Redo, as Rollback is to undo. ...
Procedure in package perfomes fastly over normal procedure, Explain.
Latest Answer: Packaged procedure can be overloaded.Packaged procedure implementation is hidden as only specification is required for refering packaged procedure.Packaged procedure when compiled i.e. when package body is compiled all other objects referring packaged ...
What is the purpose of Ref Cursor and OUT Parameter in PLSQL Function? Give Examples for each?
Latest Answer: By Ref cursor we can send record set to the calling programLike .NET VB page can get recordset as datatable from ref cursor returned by a procedure.OUT parameter sends only one value from procedure ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
