DML Commands (Data Manipulation Language) in Oracle

#SQL
#PLSQL
#Oracle
#ORACLEAPPS
#OracelFusion
#TechTalkswithNaresh
#Naresh
#R12
#EBSConsultant

Join Our Telegram Group:

FOLLOW US :
============

For More details Contact Us:

--------------------------------------------------------------------------------------------------------------------------------------------------------

This video will help them who are in the learning phase of SQL. If you have any doubt's regarding this video write in comment section. If you want any other video related to SQL please comment in comment section. Please Like,Share and Subscribe the video.

DML Commands:
SELECT: Syntex: select * from table_name;
E.g: SELECT * FROM Demo;

INSERT: Syntex: INSERT into table_name (column1,column2) values (value1,value2)
E.g: INSERT INTO demo
( customer_number, Customer_name, bank_name, Account_Number, Acc_start_date, Balance)
VALUES
(100,'AJAY','SBI',54871845,'01-JAN-2019',12345678.1231231313132333232323232);

UPDATE: Syntex: update table_name set column_name = value;
E.g: UPDATE Demo SET bank_name = 'STATE_BANK' WHERE customer_number =100;

DELETE: Syntex: Delete from table_name where condition;
E.g: DELETE FROM Demo WHERE bank_name = 'STATE_BANK';
DELETE FROM Demo WHERE bank_name LIKE 'S%';