Oracle Articles Examples, Tutorials and Articles
Published by
1. Overview
A cursor is any SQL query executed by Oracle server. For every cursor, Oracle server follows similar execution cycle. We shall discuss the cursor execution cycle and different types of cursors available.
2. Introduction
Cursor would be best defined ...
A cursor is any SQL query executed by Oracle server. For every cursor, Oracle server follows similar execution cycle. We shall discuss the cursor execution cycle and different types of cursors available.
2. Introduction
Cursor would be best defined ...
Published by
1. Overview
Oracle provides conversion functions to change an input into compatible data type family. Below article explains the conversions and format masking done by TO_CHAR and TO_DATE functions.
1. TO_CHAR
TO_CHAR function is used to typecast a numeric ...
Oracle provides conversion functions to change an input into compatible data type family. Below article explains the conversions and format masking done by TO_CHAR and TO_DATE functions.
1. TO_CHAR
TO_CHAR function is used to typecast a numeric ...
Published by
1. Overview
INSTR and SUBSTR are string functions which perform basic utilities functions on input string to return number and string output respectively. The article explains the usage of INSTR and SUBSTR functions.
2. INSTR function
INSTR ...
INSTR and SUBSTR are string functions which perform basic utilities functions on input string to return number and string output respectively. The article explains the usage of INSTR and SUBSTR functions.
2. INSTR function
INSTR ...
Published by
1. Overview
Many large applications make extensive use of Temporary data storage. Oracle implements the feature in Temporary tables. The article explains the features, restrictions, usage of Global Temporary tables.
2. Introduction
Global temporary tables ...
Many large applications make extensive use of Temporary data storage. Oracle implements the feature in Temporary tables. The article explains the features, restrictions, usage of Global Temporary tables.
2. Introduction
Global temporary tables ...
Published by
Finance department usually work extensively with Microsoft Excel ... and even though we are implementing Oracle, the question of publishing in Excel usually pops up sooner or later. In general, the answer is: yes, it is possible by creating an XML Publisher template (see How to create XML Publisher
...
2
Comments
Published by
Lexical parameter
These are used to replace a value dynamically at run time. Lexical parameters can dynamically replace clauses in the Select statement in the data model and even the whole select statement. It replaces any part of a SELECT statement, such as column names, the FROM clause, ...
These are used to replace a value dynamically at run time. Lexical parameters can dynamically replace clauses in the Select statement in the data model and even the whole select statement. It replaces any part of a SELECT statement, such as column names, the FROM clause, ...
Published by
1. Overview
In Oracle, entity integrity of the data is maintained by enforcing UNIQUE and PRIMARY KEY constraints. The article explains the important aspects of Unique constraints in Oracle.
2. Introduction
Unique constraint implements entity integrity of ...
In Oracle, entity integrity of the data is maintained by enforcing UNIQUE and PRIMARY KEY constraints. The article explains the important aspects of Unique constraints in Oracle.
2. Introduction
Unique constraint implements entity integrity of ...
Published by
1. Overview
Entity and referential integrity enforce the rules upon the attributes i.e. they re-structure the attribute properties. But Domain integrity restricts the scope of value that an attribute can accept. The article explains the use of Check constraint in Oracle
...
Entity and referential integrity enforce the rules upon the attributes i.e. they re-structure the attribute properties. But Domain integrity restricts the scope of value that an attribute can accept. The article explains the use of Check constraint in Oracle
...
Published by
1. Overview
Data Integrity is one of the important dimension to be maintained in database. The article explains the implementation and use of Primary key constraint in Oracle.
2. Introduction
Primary key is one of the data integrity constraints which technically ...
Data Integrity is one of the important dimension to be maintained in database. The article explains the implementation and use of Primary key constraint in Oracle.
2. Introduction
Primary key is one of the data integrity constraints which technically ...
