SQL Oracle Java JSP JDBC PHP MORE

ORACLE Tutorials

❮ Previous Next ❯

Oracle is a relational database management system. It is widely used in enterprise applications.

By using Oracle we can we can create database and its object like table view and index.

We have to write Oracle Query to perform any kind of operation on database.

Key Statement of ORACLE:

Insert Statement

Select Statement

Update Statement

Delete Statement

Insert Statement Query

INSERT INTO table_name (column1,column2,column3,...) VALUES (value1,value2,value3,...);

Select Statement Query

SELECT column_name,column_name

FROM table_name;

and

SELECT * FROM table_name;

Update Statement Query

UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value;

Delete Statement Query

DELETE FROM table_name;

or

DELETE * FROM table_name;

❮ Previous Next ❯