SQL Oracle Java JSP JDBC PHP MORE

ORACLE Tutorials

Oracle is a robust and highly popular relational database management system (RDBMS) developed by Oracle Corporation. It is widely used in enterprise applications.

Oracle Database uses SQL (Structured Query Language) to manage and query data.

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

Oracle Database uses SQL (Structured Query Language) to manage and query data. Here are some fundamental SQL commands:

Craete Table Query

CREATE TABLE employees (
employee_id NUMBER(5) PRIMARY KEY,
first_name VARCHAR2(50),
last_name VARCHAR2(50),
hire_date DATE
);

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;