Software Engineering and Testing

ORACLE 339

To Add a New Column in a Table

Syntax

SQL> alter table student add(date_of_birth date,address

varchar2(50));

Data Insertion in a Table

Character and date values are inserted with single quotes (‘) at the beginning and

at the end, whereas numeric values are inserted without single quotes. The date

value is inserted in the format ‘dd-mmm-yy’, i.e., ‘01-APR-05.’

Syntax

SQL> insert into student values (‘Anshul’,12,’Seventh’,’02-MAR-

03’,20000);

Data Selection

To select all the records from a table:

Syntax

SQL> select * from student;

To select few fields from a table:

Syntax

SQL> select Name,Age,Class from student;

This statement will show only Name, Age, and Class of all records from the

table student.

Conditional ...