...

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.
1>
Oracle Select Query Prophet select inquiry is utilized to get records from data set. For example:

SELECT * from customers;


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

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


3>
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;

4>
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;
 


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

shorten table customers;


6>
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;  


7>
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>
>
;


8>
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>
;