A PL/SQL Block consists of three sections: 1.The Declaration section (optional). 2.The Execution section (mandatory). 3.The Exception (or Error) Handling section (optional). Sample below : […]
Category: Oracle 9i Tutorial
What are few Oracle DDL statements or commands ?
Below are few DDL commands to create, alter, drop, and rename tables. CREATE TABLE Create a table. Create a table based on another table by […]
Oracle 9i Tutorial : What is syntax of DELETE Statement Syntax
You can remove existing rows by using the DELETE statement. Delete Statement Syntax below : DELETE [FROM] table [WHERE condition];
Oracle 9i Tutorial : UPDATE Statement Syntax
UPDATE Statement Syntax Update Statement is used to modify existing rows in table. Below is Update State Syntax : UPDATE table SET column = value […]
Oracle 9i Tutorial : INSERT Statement Syntax
INSERT Statement Syntax INSERT statement is used to add new rows to table.Syntax of INSERT statement below : Only one row can be inserted at […]
Oracle 9i Tutorial : Data Manipulation Language
Data Manipulation Language ( DML ) A DML statement is executed when you: –Add new rows to a table –Modify existing rows in a […]
Oracle 9i Tutorial : Adding Comments to Table
Adding a Comment to a Table You can add a comment of up to 2,000 bytes about a column, table, view, or snapshot by using […]
Oracle 9i Tutorial : Drop,Rename and Truncate table
DROP TABLE Remove rows and a table structure. Once executed, this statement cannot be rolled back. -DROP TABLE EMPLOYEE RENAME […]
Oracle 9i Tutorial : ALTER TABLE Statement
ALTER TABLE Statement After you create a table, you may need to change the table structure because: you omitted column, your column definition needs […]
Oracle 9i Tutorial : Creating a Table by Using a Subquery Syntax
Creating a Table by Using a Subquery Syntax •Create a table and insert rows by combining the CREATE TABLE statement and the AS subquery option. […]