25 min read
This content is password protected. To view it please enter your password below: Password:
SQL
25 min read
1 min read
In case if we want to identify duplicates rows of a table and want to remove them from a table. ...
4 min read
What is Recovery Catalog? A recovery catalog is a database schema used by RMAN Which is used to stored Metadata...
1 min read
SELECT NAME ,OPEN_MODE FROM V$DATABASE;SELECT LOG_MODE FROM V$DATABASE;SELECT NAME FROM V$DATAFILE;SELECT NAME FROM V$TABLESPACE; CREATE TABLESPACE(TB1) RMAN > BACKUP DATABASE...
1 min read
The ROW_NUMBER built-in SQL function provides superior support for ordering the results of a query. ROW_NUMBER is an analytic function....
2 min read
Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time...
2 min read
For each row in the database, the ROWID pseudocolumn returns the address of the row. Every table in an Oracle...
3 min read
SQL Macros You can create SQL macros (SQM) to factor out common SQL expressions and statements into reusable, parameterized constructs...
1 min read
The Oracle COALESCE() function accepts a list of arguments and returns the first one that evaluates to a non-null value. The following...
5 min read
Overview of Triggers A database trigger is a compiled stored program unit, written in either PL/SQL or Java, that Oracle...
4 min read
Character Data Types: • CHAR Data Type • VARCHAR2 Data Type • VARCHAR Data Type • NUMBER Data Type CHAR...
3 min read
Primary Key Constraints A primary key constraint designates a column as the primary key of a table or view. A...
2 min read
Data Concurrency A requirement of a multiuser RDBMS is the control of data concurrency, which is the simultaneous access of...
3 min read
A transaction is a logical, atomic unit of work that contains one or more SQL statements. A transaction groups SQL...
1 min read
Data Consistency In Oracle Database, each user must see a consistent view of the data, including visible changes made by...
3 min read
Structured Query Language (SQL) is the set of statements with which all programs and usersaccess data in an Oracle Database....
3 min read
In Oracle Database, a database schema is a collection of logical data structures, or schema objects. A database user owns...
3 min read
The pattern-matching conditions compare character data. LIKE Condition * The LIKE conditions specify a test involving pattern matching. Whereas the...
2 min read
The dynamic performance views are special views that are continuously updated while a database is open and in use. Throughout...
2 min read
A check constraint on a column or set of columns requires that a specified condition be true or unknown for...
4 min read
NOT NULL Constraints The NOT NULL constraint ensures that the column contains no null values. Columns without the NOT NULL...
