Scribd
Upload
125 views6 pages

SQL & Oracle Guide for Beginners

This document discusses various Oracle database concepts including SQL, PL/SQL, database objects like tables and views, different versions of Oracle from 8i to 19c, and commonly used client-side tools for interacting with Oracle databases like SQL Developer and SQL*Plus. It also provides examples of SQL queries to retrieve data from tables in the employees schema as well as from data dictionary views to view metadata about database objects.

Uploaded by

Vinoth Sivaperumal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
125 views6 pages

SQL & Oracle Guide for Beginners

This document discusses various Oracle database concepts including SQL, PL/SQL, database objects like tables and views, different versions of Oracle from 8i to 19c, and commonly used client-side tools for interacting with Oracle databases like SQL Developer and SQL*Plus. It also provides examples of SQL queries to retrieve data from tables in the employees schema as well as from data dictionary views to view metadata about database objects.

Uploaded by

Vinoth Sivaperumal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

01_Retriving_Data_06042020.

sql

Software

Front End(UI) Backend(Database)

Oracle - Java (OCJP) Oracle (SQL & PLSQL)


Microsoft .net MS SQL Server (SQL & TL/SQL)
Php Oracle - Mysql
IBM - Mainframe IBM DB2
Moble App Dev.. SQl Lite
Postgre
Sybase
Teradata
Mango Db
..
...
....

SQL - Structured Query Language

Command line which is used to interact with any database.

Students | Freshers | Exep

Introduction
Diff Tracks in Oracle
Oracle SQL 20% | 100% (80%)
Oracle PL/SQL
Expert Level PL/SQL
Functional
Process
DEV | ENH CNG PROD Support
Unix
Unix Shell Scripting
Oracle Arch (KT)
Testing (KT)
Performance Tuning
...
..

Oracle C 1970 - 2020

Oracle 8i 9i 10g 11g 12c 13c 18c 19c 20c

i -> internet
g -> Grid
c -> Cloud

New Features?

Oracle 10g Express Edition

VLC -> Next -> Next -> Next -> sys | sys -> Next -> Next -> Next -> Finish

Start -> Oracle Database 10g Express Edition -> System | sys -> Admin ->
Database User

1. Password
2. Locked -> Unlocked
3. Check DBA Option
4. Check All Option
5. Alter user

Hr/open SQL SQL Commands

Oracle - Database

User -> Schema


Row -> Records
Output -> Resultset
107 rows returned in 0.02 seconds -> Feedback

Database

Schema (user)

Schema Objects

Table View Sequence Synonyms Index


Stored Procedure Function Package Triggers Type

Table _tb Basic Unit Of Storage


Rows + Columns
View _vw Logical Representation of subset of records
View wont contains any data
Sequence _seq Generate Unique Number
Synonyms _syn Used to Provide alternate name to any object
Index _ind one of the PT method Used to improve the performance

1 2 3 4 5.......999999999..(27)
1..500 1..501..500 100% Cycle is possible

564 D
564 P

AMZ FLK ODR REF CR SR


06042020
00567

INC0204202000564
INC0304202000564 79567345

employees -> emp


locations -> loc

XE - Database EE

HR SR
SELECT * FROM employees;
SELECT * FROM [Link]; SELECT * FROM [Link]; SELECT * FROM
[Link]@dblink;

enh_db rps2_blltr_deal_main_txn_tb

enh_db.rps2_blltr_deal_main_txn_tb@dblink => dmain

SELECT * FROM dmain;

employees 1000 emp

--Session_01

Oracle Database Gmail

Client Side Tools

isqlplus - Mozilla Firefox [Just for Practice Purpose] IE


sqlplus Firefox
SQL Developer (Oracle) GC
PLSQL Developer
Toad (Dell)

SELECT FROM Clause

User Table
Contain User Data
Created and Maintained by user

SELECT * FROM employees;


SELECT * FROM departments;
SELECT * FROM locations;

Data Dictionary Table


Contain Database Information
Created and Maintained by Database

SELECT * FROM user_tables;


SELECT * FROM all_objects; -- owner | object_name | object_type | status

SELECT * FROM employees;

SELECT employee_id, first_name, hire_date, salary, department_id FROM employees;


SELECT owner, object_name, object_type, status FROM all_objects;

Notepad++

You might also like