Informatica PowerCenter Batch-25 Session-2 | Introduction to Oracle SQL | SQL Basics | SQL Tutorial

Published: 12 August 2024
on channel: Raj Informatica Realtime HandsOn JobBased Training

568

👉 Join Informatica IICS(IDMC) WhatsApp group: https://chat.whatsapp.com/KlCxKZZNqO7...

Raj Cloud Technologies Informatica PowerCenter Realtime online Training
👉 Join Informatica PowerCenter WhatsApp group: https://chat.whatsapp.com/FMcfXIJTbp9...

☎️ Contact: 8105296858
Website : https://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

On this page of the site you can watch the video online Informatica PowerCenter Batch-25 Session-2 | Introduction to Oracle SQL | SQL Basics | SQL Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Raj Informatica Realtime HandsOn JobBased Training 12 August 2024, share the link with friends and acquaintances, this video has already been watched 568 times on youtube and it was liked by 9 viewers. Enjoy your viewing!

156