Latest Answer: Through flash back queries you can get the data which has been deleted permanently. Different types of methods are there : Use the following links to get the complete information :http://download.oracle.com/docs/cd/B14117_01/appdev.101/b10795/adfns_fl.htm ...
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: Roll forward refers to the process Oracle goes through to apply changes contained in the redo log files (both online and archive). The database clock (as measured by the system change number) is moved forward within the blocks of the datafile that are ...
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: Ref cursor is used when we need to assign different select statment for a single cursor in executable section.where as out parameter is used in procedures and functions to bring out the output from a PL/SQL block. ...
What are Return Statement and OUT Parameter in PLSQL Function?
Latest Answer: Function must have return statement by which it returns one value.Though we can use out parameter in function(function not getting called from select statement or DML), it is not good programming practice to write OUT and IN OUT in function. In case we ...
How can we generate debugging output from PL/SQL?
Latest Answer: stshekhar is right, oracle supplied package DBMS_OUTPUT with procedures PUT, PUT_LINE, NEW_LINE etc in case of debugging pl/sql ...
we can create a column with' not null+unique' with out using primary key
Latest Answer: 1) Primary key creates clustered index by default which actually reorders the row in a table based on index while unique key creates non-clustered index.2) Replication of table possible only if it contains primary key. ...
How can the error line can be identified for a package at run time ?
Latest Answer: Starting from Oracle 10G we can use DBMS_UTILITY.FORMAT_ERROR_BACKTRACE function to get the line from where the error originated. ...
Hi All,I have requirement of sending the records based on the input received from web.I have a ref_cursor returning 30 rows..Here I am supposed to do paging on the set of records present in the above ref
Latest Answer: First you have to filter the no of records you need totally (i.e., if you receive input as 2 and if the no of records you need to return are 20, then you need to filter 20 rows) using where rownum ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
