Material Link : drive.google.com/drive/folder...
👉 Join Informatica IICS(IDMC) WhatsApp group: chat.whatsapp.com/KlCxKZZNqO7...
Raj Cloud Technologies Informatica PowerCenter Realtime online Training
👉 Join Informatica PowerCenter WhatsApp group: chat.whatsapp.com/CLtOBgRKtBW...
☎️ Contact: 8105296858
Website : rajinformatica.com/informatic...
ORACLE - SQL - STRUCTURED QUERY LANGUAGE
--------------------------------------------
DDL COMMANDS - DATA DEFINIATION LANGUAGE - CREATE , ALTER , DROP ,RENAME , TRUNCATE
DML COMMANDS - DATA MANIPULATION LANGUAGE- INSERT , UPDATE , DELETE
TCL COMMANDS - TRANSACTION CONTROL LANGUAGE - COMMIT , ROLLBACK
DQL COMMANDS - DATA QUERY LANGUAGE - SELECT
DCL COMMANDS - DATA CONTROL LANGUAGE - GRANT , REVOKE
TO WORK ON ABOVE ORACLE COMMANDS ,
YOU SHOULD INSTALL ORACLE SERVER 11G
YOU SHOULD INSTALL ORACLE SQL DEVELOPER.
1. create a schema in oracle sql developer.
CREATE USER OT_SRC_DEV15 IDENTIFIED BY admin;
GRANT ALL PRIVILEGES TO OT_SRC_DEV15;
GRANT DBA TO OT_SRC_DEV15;
2. CREATE A TABLE DEFINITION OR STRUCTURE OF THE TABLE.
CREATE TABLE STUDENTS
(
ST_ID NUMBER(3),
ST_NAME VARCHAR2(50),
MARKS NUMBER(5,2),
CITY VARCHAR2(100)
);
3. TO SEE THE DEFINITION OR STRUCTURE OF THE TABLE
DESC STUDENTS;
4. TO SEE THE DATA/ ROWS IN A TABLE
SELECT * FROM STUDENTS;
5. TO INSERT THE RECORDS/DATA INTO THE TABLE.
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (1,'RAJ',99.95,'BNAGALORE');
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (10,'RAM',100.1,'CHENNAI');
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (150,'RAMYA',999.99,'MUMBAI');
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (200,'DIVYA',0,'GOA');
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (300,'JOHN',14,'PUNE');
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (999,'RAJESH',200,'MYSORE');
6. HOW TO SAVE THE RECORDS FROM A TABLE ?
COMMIT;
7. How to see the count of the records?
Select count(*) from Students;
DDL- DATA DEFININATION LANGUAGE - CREATE , ALTER , DROP , RENAME , TRUNCATE
DML- DATA MANIPULATION LANGUAGE - INSERT , UPDATE , DELETE
TCL- TRANSACTION CONTROLM LANGUAGE - COMMIT , ROLLBACK
DQL- DATA QUERY LANGUAGE - SELECT
CREATE - TO CREATE A NEW TABLE
INSERT - TO INSERT THE NEW RECORD
COMMIT - TO SAVE THE RECORDS
SELECT - TO SEE THE RECORDS
DESC - TO SEE STR/DEF OF A TABLE
WHERE - TO SEARCH/FILTER THE RECORDS FROM A TABLE
COUNT(*) - TO SEE COUNT OF THE RECRODS FROM A TABLE.
ALTER
-----
Alter table Add - add the new columns to the table
Alter table drop - Remove the columns from a table
Alter table modify - Modify the datatypes in a table
Alter table rename - Rename the column names in a table.
1. How to create a schema called ot_src_dev2 ?
2. Configure the Schema OT_SRC_DEV2
3. Learn Basic SQL commands in Oracle
4. Create a table in oracle
5. How to see the records in a table ?
6. INSERT THE RECORDS INTO THE TABLE
7. Save the records into the table
8. How to See the structure/definition of a table?
9. see the count of records from a table
10.How to search the records from a table