Oracle


ORACLE
----------
---BY ORACLE CORPORATION : 1973 : LAURENCE ELLSION
  |
    FIRST PRODUCT : SYSTEM/R :1975
    ORACLE 2.0/3/4/5/6/7/7.3 : RDBMS
    ORACLE 8.0  : ORDBMS
    ORACLE 8I,9I,10G,11G : OODBMS
------------------------------------------------------
Q:  DBMS & RDBMS ???
----------------------
------X---
TYPES OF DBMS:
--------------------
1. HDBMS
2. NDBMS
3. RDBMS
4. ORDBMS
5. OODBMS

ANS : E.F.CODE : 13 RULES (0-12)
< 6= DBMS
> 6= RDBMS

ORACLE : 12.5 RULES

Q: 8I / 9I : INTERNET
|
ORACLE JVM INBUILT ... JVM FOR JAVA : JAVA-LANG FOR INTERNET

Q: 10G/11G : G : GRID COMPUTING
--CHAIN OF SERVER ---

 SERVER1     SERVER2   SERVER3     SERVER4
   -----------------------------------
SHARING

ORACLE
-----------
|
1. SQL : ANSI STND LANGUAGE
2. SQL * PLUS : ENVIRONMENT
3. PL/SQL : PROG LANGUAGE
----------------------------------

SQL SQL * PLUS
---------                                       ----------------------------
1. LANG                     1. ENVIRONMENT
2. ANSI                     2. ORACLE PRODUCT
3. SHORT FORM NOT ALLOWED  3. SHORT FORM ALLOWED
  SELECT --SEL---X                     CLEAR SCREEN : CL SCR
       DESCRIBE    : DESC
        SAVE        : SAV
4. LINE TERMINATE ; REQUIRED           4. NO ; REQUIRED
 SELECT * FRO  M EMP;      CL SCR
--------------------------------------------------------

SQL COMMANDS
------------------
1. DATA RETRIVAL : SELECT
2. DML  : INSERT UPDATE DELETE
3. DDL  :  CREATE ALTER DROP RENAME TRUNCATE
4. DCL  : GRANT REVOKE
5. TCL  : COMMIT ROLLBACK SAVEPOINT
--------------------------------------
14 COMMANDS
SQL * PLUS COMMAND
-------------------------
EDIT -ED / SAVE -SAV / CLEAR SCREEN -CL SCR
SPOOL / CONNECT / EXIT
------------------------------------------------------------------
ORACLE INSTALL : ORACLE EXPRESS

---START SQL COMMAND LINE :
SQL>

--------------------------------------------------------------------
ORACLE : USER

ORACLE 8I 9I/10G
-------------- ------------
     INTERNAL : ORACLE SYS : PASSWORD , INSTALLTION
     SYS      : CHANGE_ON_INSTALL SYSTEM :   "         "
     SYSTEM   : MANAGER ---------------------------------
     SCOTT    : TIGER

 FIRST TIME
 -------------
SQL>CONNECT / AS SYSDBA
SQL>GRANT CONNECT,RESOURCE,DBA TO SCOTT IDENTIGFIED BY TIGER
SQL>CONNECT SCOTT/TIGER
 2ND/NEXT TIME
 ------------
SQL>CONNECT SCOTT/TIGER

----------------------------------------------------------------------------
SELECT STMT
---------------
TO GET THE DATA FROM TABLE
SYN : SELECT COLNAME FROM TABLE (MUST)
     WHERE CONDITION           (OPTIONAL)
     GROUP BY COLNAME    "
     HAVING CONDITION    "
              ORDER BY COLNAME    "
    --------------------------
-->WE CANT CHANGE SEQUENCE ...

ORACLE : DEMOSTRATION TABLE
|--EMP/DEPT
--DEMOBLD.SQL
SQL>@D:\DEMOBLD.SQL
--OARCLE..EMP,DEPT TABLE ..READY
------------------------------------------------------------------------------

Comments

Post a Comment

Popular posts from this blog

Top Attractions on the Varanasi Tour

  VARANASI TOUR Introduction Varanasi , often referred to as Kashi or Banaras , is one of the oldest living cities in the world, steeped in history, culture, and spirituality. Located on the banks of the sacred Ganges River in Uttar Pradesh , India, Varanasi is a center for Hindu rituals, ancient temples, and vibrant cultural traditions. A Varanasi tour offers an opportunity to witness a unique blend of spirituality and everyday life as locals perform daily rituals, pilgrims bathe in the Ganges, and sacred chants echo through the streets. From witnessing the stunning Ganga Aarti at the ghats to visiting the renowned Kashi Vishwanath Temple , a Varanasi tour is a deeply immersive experience. Here’s a guide to the must-visit attractions and experiences that will make your trip to Varanasi unforgettable. Top Attractions on the Varanasi Tour Kashi Vishwanath Temple The Kashi...
Read more

Dev Diwali 2025 – 6 Reasons Why You Shouldn’t Miss It!

Image
Dev Deepawali or Dev Deepawali in Varanasi is celebrated on Kartik Poornima , the full moon of the Hindu month of Kartik, fifteen days after Diwali . Dev Deepawali is not standalone, in itself. It is celebrated on the last day of Ganga Mahotsav , which begins on Prabodhini Ekadashi (11th day of the Lunar month of Kartik) and ends in Dev Deepawali which will fall on  November 15 this year . It is interesting to note that Dev Deepawali in Varanasi also coincides with Guru Nanak Jayanti and Jain Light Festival. Dev Deepawali Date 2025 November 05, 2025 Not to be confused with Deepawali (or Diwali), Dev Deepawali or Dev Diwali in Varanasi is a festival celebrated every year on the occasion of Kartik Poornima. This happens to be 15 days after Diwali. This year, Dev Deepawali in Varanasi will be on November 05, 2025. For most travellers and spiritual seekers alike, Varanasi is a dream destination. People from all over...
Read more

Summer Special Kashi Tour Packages

  Summer Special Kashi Tour Packages by Shivakashi Travels 1. Kashi Tour Package – 2 Days / 1 Night Highlights : Visit to New Kashi Vishwanath Temple ( BHU), Sankat Mochan Temple, Durga Temple, Tulsi Manas Mandir, and evening Ganga Aarti at Dashashwamedh Ghat. Additional : Optional boat ride on the Ganges ( direct payment). Inclusions : Hotel accommodation, breakfast, and local sightseeing. More Info : Shivakashi Travels Shivakashi Travels +3 Shivakashi Travels +3 Shivakashi Travels +3 Shivakashi Travels 2. Kashi Tour Package – 3 Days / 2 Nights Highlights : Day 1 : Arrival and temple visits in Varanasi. Day 2 : Excursion to Prayagraj ( Triveni Sangam, Hanuman Temple, Anand Bhawan) and Sitamarhi. Day 3 : Visit to Sarnath, including Dhamek Stupa and the 80- feet Buddha statue. Inclusions : Hotel accommodation, breakfast, and sightseeing. More Info : Shivakashi Travels Shivakashi Travels +3 Shivakashi Travels +3 Shivakashi Travels +3 Shivakashi Travels +1 Shiv...
Read more