Latest Answer: 1. Procedure Overloading and Function Overloading Possible in Package. This Overloading Concept Not Possible in Procedure.2. Variables in Package we Can use as a Global Variables. it's Not Possible in Procedure. ...
Latest Answer: Cold Backup is possible only when the database is down means it is not available to users to access. Disadvantage is we effort downtime. Here we need to take backup of datafiles, control files, redo files. Here we get consistent backup image.Hot backup ...
Latest Answer: Dear All,LIFE OF SQL STATEMENTStep 1: Oracle Create a CursorFor every SQL, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor). Step 2: Oracle Parse SQL StatementA SQL statement is parsed only if an identical ...
Latest Answer: Instance is the memory structures and background processes used to interact with Database.Instance = SGA + Background ProcessDatabase is the physical files used to store information. the 3 types of physical files are: Datafiles, Control File and ...
Latest Answer: Where current of is used for updating the data referenced by cursor which was created as "SELECT FOR UPDATE".DECLARECURSROR MY_CURR IS SELECT COL1, COL2, COL3,...,COLN ...
Latest Answer: To execute sqlplus via Unix shell scripts the following parameters need to be initialized.(1.) ORACLE_HOME export ORACLE_HOME=Path to (2.) ORACLE_SIDexport ORACLE_SID=Actual ORACLE_SIDAfter these initializations have been done use sqlplus ...
Latest Answer: The only difference between rownum and level pseudocolumn isRownum is used to order the datas according to their ranks and it is used in inline views..Level pseudocolumn is used in hierarchial retrival of database..... ...
Latest Answer: The varchar2(30) will take 30 bites. Because the size is specified as 30. if you entered a data of only 20 chars the remaining 10 will be transformed to the other field or row. By this the wastage of the disk space can be minimised. ...
Latest Answer: The way the data maintained in the collection of tables can be explained by the data structure. The structure of database will show on which conditions the database will be maintained with out inconsistancy. ...
Latest Answer: One time procedure, Its actually not a procedure but its called as one time procedure, Why because this used to initialize variable, calling function or procedure once the scope of package for user session.This can be defined like this..Package Body Aa ...
View page << Previous 1 [2] 3 4 5 Next >>
Go Top
