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: And the primary purpose of one time procedure is for one time initialisation of package variables ...
Create a query that will display the total no.of employees and, of that total, the no.of employees hired in 1995,1996,1997, and 1998. create appropriate column headings.
Create a matrix query to display the job, the salary for that job based on department number and the total salary for that job, for departments 20,50,80, and 90,giving each column and appropriate heading.
View page << Previous 1 [2] 3 4 5 Next >>
Go Top
