Database Learning (Oracle)

Oralce Data types

Number,varchar2,char,date

Storage encoding for Char and VARCHAR2:

Maximum length of char and VARCHAR2:

Long and CLOB types

To create a table:

Create statement, creating a table

DESC statement, viewing table structure

Default statement, specifying a value for the column

NOT NULL constraint to ensure that field values are not empty

------------------------------------------------

To modify a table:

RENAME Modify Table name: RENAME old_name to New_name;

ALTER TABLE adds a column to the ADD clause:

ALTER TABLE DROP clause delete column: ALTER TABLE table_name drop (column);

ALTER TABLE's MODIFY clause modifies the column:

DML statement:

Insert,update,delete

String functions:

Concat and "| |", string connection

Length returns string lengths

Upper,lower and Initcap uppercase and lowercase conversion functions

Trim,ltrim,rtrim truncate SUBSTRING

Lpad,rpad-Complement function

Substr getting substrings

InStr returns the position of the substring in the source string

Numeric functions:

Round for rounding

Trunc for interception

MoD to find remainder

Ceil and floor

Date:

Database Learning (Oracle)