Oracle: Package
PL/SQL package is a logical grouping of a related subprogram (procedure/function) into a single element. A Package is compiled and stored as a database object …
Read MBA, BBA, B.COM Notes
PL/SQL package is a logical grouping of a related subprogram (procedure/function) into a single element. A Package is compiled and stored as a database object …
A function is a subprogram that is used to return a single value. You must declare and define a function before invoking it. It can …
A procedure is a group of PL/SQL statements that can be called by name. The call specification (sometimes called call spec) specifies a java method …
Triggers are stored programs that are fired automatically when some events occur. The code to be fired can be defined as per the requirement. Oracle …
A cursor is a pointer to a private SQL area that stores information about the processing of a SELECT or DML statements like INSERT, UPDATE, …
Unique and Nonunique IndexesUnique indexes guarantee that no two rows of a table have duplicate values in the key column (or columns).For performance reasons, Oracle …
A Snapshot is a recent copy of a table from db or in some cases, a subset of rows/cols of a table. They are used …
In Oracle, INSERT statement is used to add a single record or multiple records into the table. Syntax: (Inserting a single record using the Values …
Constraints can be specified when the table is created with the CREATE TABLE statement, or after the table is created with the ALTER TABLE statement. …
In Oracle, CREATE TABLE statement is used to create a new table in the database. To create a table, you have to name that table …