NVL, NVL2, NULLIF, COALESCE, DECODE, CASE Functions in Oracle

Character case conversation functions and character Manipulation functions and Date functions in oracle

Types of functions in oracle

Ampersand substitution in Oracle

Ampersand substitution in Oracle :

Composite sorting in Oracle

Composite sorting in Oracle :

Positional sorting in Oracle

Positional sorting in Oracle :

Sorting Data in a table

Different sorting mechanisms:

How to use Escape operator in oracle

How to use Escape operator in oracle:

Comparison operators in oracle

Comparison operators in oracle:

How to use quote operator in oracle

Quote operator in Oracle

Select statement representation in relational algebra and relational theory

Select statement representation in relational algebra and relational theory :

what are SQL commands

SQL commands are

Different roles while application development

Different roles while application development:

How to select specific record from last or first

How to select specific record from last or first:

Select col1,col2,col3 from(selectcol1,col2,col3, row_number() over(order by col4,col5 desc) RN)
Where RN=2;

Note: to select second record from last

Create temporary table in Oracle

     Temporary tables are stored in main memory which will be alive until the session expires. We can use like normal tables but these can not be permanent and can't reflect in the memory (Hard-disc).
Syntax:

SQL> CREATE GLOBAL TEMPORARY TABLE marks_tmp
  2  (  std_id     numeric(10)     not null,
  3     std_name   varchar2(50)    not null,
  4     marks      varchar2(50)
  5  )
  6  /
SQL>
SQL>