Tag Archives | PL/SQL

Oracle – Create Table by Select Statement

–WITH data –without data — For example, create a table named EMPLOYEE3 that includes all — of the column definitions from EMPLOYEE where the DEPTNO = D11.

Read full story Comments { 0 }

Oracle PL/SQL – Finding number of rows in each table by a single query

Sample: Results: OR

Read full story Comments { 0 }

Oracle PL/SQL – SQL Plus Startup Script with glogin.sql or login.sql

This article shows about how to configure the environment variable when SqlPlus – SqlPlus Command start up in order to have always a good behavior in the formatting of the result. You have to setup the Windows – Environment Variable (SQL Plus|SQL Developer)- SQLPATH with a directory. Copy then the file login.sql described below in […]

Read full story Comments { 0 }

Oracle – Create Table – Using Select Statement With Data or No Data

Here is a sample script: WITH data   CREATE TABLE test3 AS SELECT table_name, tablespace_name FROM all_tables;   ———————————   Without data   CREATE TABLE ctas AS SELECT table_name, tablespace_name FROM all_tables WHERE 1=2;     — For example, create a table named EMPLOYEE3 that includes all — of the column definitions from EMPLOYEE where […]

Read full story Comments { 0 }

SQL CHECK Constraint

SQL CHECK Constraint The CHECK constraint is used to limit the value range that can be placed in a column. If you define a CHECK constraint on a single column it allows only certain values for this column. If you define a CHECK constraint on a table it can limit the values in certain columns […]

Read full story Comments { 0 }

Restoring a SQL Database Backup Using SQL Server Management Studio

Restoring a SQL Database Backup Using SQL Server Management Studio

Read full story Comments { 0 }

How to Replace Default Date Value if Date Field is NULL with PL/SQL

How to Replace Default Date Value if Date Field is NULL with PL/SQL

Read full story Comments { 0 }