03/15/10
The SQL statement which are built at run time are called the Dynamic SQL. Dynamic SQL can be built by using DBMS_SQL package. A Package is a PL/SQL Construct that allow related object to be stored together.
How do u call a Package? Cursor is a private SQL area created in SGA to do multi row operation in a PL/SQL programme
An Index is a DB object, which is used to improve the performance of the data retrieval.
Equi Join: When primary and foreign key relationship exists between the tables that are going to be joined. Tag cloud«all_source table»,«alter data type of column having data»,«ascii for newline and tab»,«b-tree indexes»,«bitmap indexes»,«bulk collect»,cardinality,«column constraints»,«constraints on a table»,«control files»,cube,«ddl commands inside pl/sql proc»,«debugging a procedure»,«delete duplicates»,«describing a package body in sql plus»,«duplicate records»,«dynamic table creation in stored procedure»,«export saved database connections in toad»,«grants of an object»,«mutliline data in oracle»,«number of columns in a table»,«oracle aggregate functions»,«oracle data loader»,«oracle product version»,«oracle version»,«pragma autonomous_transaction»,rollup,«source code of a package»,«special characters in varchar2 column»,sql*loader,«toad database connections file»,user_tab_columns,user_tab_privs |
Hit Counter |
07:37:51 am, by 
XML Feeds