USE : user_source tableselect * from user_source where type = ‘PROCEDURE’ and lower(text) like lower(‘%text%’);
Category: Oracle Interview Questions
Oracle DECODE function
Oracle DECODE function Oracle decode function allow to transform data values at retrieval time. Syntax : DECODE(expr, search, result [, search, result ]… [, default […]
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 […]