Database Managment - Oracle

Back to Course

Lesson Description

Lession - #1415 Oracle Queries

Oracle Queries

You can execute many questions in oracle data set like addition, update, erase, change table, drop, make and select.
Oracle Select Query Prophet select inquiry is utilized to get records from data set. For example:

SELECT * from customers;

Oracle Insert Query Prophet embed inquiry is utilized to embed records into table. For example:

insert into customers values(101,'rahul','delhi'>

Oracle Update Query Prophet update question is utilized to refresh records of a table. For example:

update customers set name='bob', city='london' where id=101;

Oracle Delete Query Prophet update inquiry is utilized to erase records of a table from data set. For instance:

erase from customers where id=101;

Oracle Truncate Query Prophet update question is utilized to shorten or eliminate records of a table. It doesn't eliminate structure.

shorten table customers;

Oracle Drop Query Oracle drop query is used to drop a table or view. It doesn't have structure and data. For example:

drop table customers;  

Oracle Create Query Prophet make question is utilized to make a table, view, succession, system and capacity.

Make TABLE clients
( id number(10>
NOT NULL, name varchar2(50>
NOT NULL, city varchar2(50>
, Imperative customers_pk PRIMARY KEY (id>

Oracle Alter Query Oracle alter query is used to add, modify, delete or drop colums of a table. Let's see a query to add column in customers table:

ALTER TABLE customers   
ADD age varchar2(50>