SQL

SQL

1. VIEWS

2. CONSTRAINTS

3. SQL * PLUS OPERATORS

   • BETWEEN AND OPERATOR
   • IN OPERATOR
   • IS NULL OPERATOR
   • LIKE OPERATOR

4. JOINS

5. HANDLING NULL VALUES

6. LITERALS

7. WORKING WITH DATES

8. WORKING WITH ALIASES

9. SUBQURIES

10. OPERATOR PRECEDENCE

11. DATATYPES

12. DML STATEMENTS

    • INSERT
    • UPDATE
    • DELETE

13. DDL STATEMENTS

    • CREATE
    • ALTER
    • DROP
    • RENAME
    • TRUNCATE

14. TCL STATEMENTS

    • COMMIT
    • ROLLBACK
    • SAVE POINT

15. DCL STATEMENTS

    • GRANT
    • REVOKE

16. DATA RETRIEVAL STATEMENTS

    • SELECT

17. TABLE CREATION

18. INSERTING DATA INTO TABLES

19. DATA RETRIEVAL STANDARDS USING SELECT STATEMENT

20. GENERAL OPERATORS

21. SQL FUNCTIONS

    • SINGLE ROW FUNCTIONS
      • CHARACTER FUNCTIONS
        • CASE CONVERSION FUNCTIONS
          • LOWER FUNCTION
          • UPPER FUNCTION
          • INITCAP FUNCTION
        • CHARACTER MANIPULATION FUNCTIONS
          • CONCAT
          • SUB STRING
          • LENGTH
          • INSTRING
          • LPAD
          • RPAD
          • LTRIM
          • RTRIM
          • TRIM
          • REPLACE
          • TRANSLATE
          • CHR FUNCTION
          • ASCII FUNCTION
      • NUMBER FUNCTIONS
        • ROUND
        • TRUNCATE
        • CEIL
        • FLOOR
        • MODULUS
        • POWER
        • SQUARE ROOT
        • ABSOULUTE
        • SIGN
      • DATE FUNCTIONS
        • SYSDATE
        • ADD_MONTHS
        • MONTHS_BETWEEN
        • NEXT_DAY
        • LAST_DAY
        • ROUNDING OF DATES
          • ROUND
          • TRUNC
      • CONVERSION FUNCTIONS
        • IMPLICIT DATATYPE CONVERSIONS
        • EXPLICIT DATATYPE CONVERSIONS
          • TO_CHAR
            • TO_CHAR (NUMBER CONVERSION)
              • DECIMAL INDICATOR D (99D99)
              • SCIENTIFIC NOTATION INDICATOR EEEE (9.9EEEE)
              • GROUP SEPERATOR (9GD99)
              • LOCALE CURRENCY INDICATOR L (L999) OR (999L)
              • TRAILING MINUS INDICATOR MI (9999MI)
              • NEGEATIVE NUMBER INDICATOR PR (9999PR)
              • ROMAN NUMBER INDICATOR (RN OR rn)
              • SIGN INDICATOR s (S99999 OR 99999S)
              • HEXADECIMAL INDICATOR X (XXXX)
              • ORIGINAL GROUP SEPARATOR (9 , 999 )
              • ORGINAL DECIMAL INDICATOR (99.99)
              • DOLLAR INDICATOR $ ($9999)
              • ZERO INDICATOR 0 (0999 OR 9990)
              • DIGIT PLACE MARKER 9 (9999)
              • ISO CURRENCY INDICATOR C (C9999)
            • TO_CHAR (DATE CONVERSION)
              • AD OR A.D. / BC OR B.C. INDICATOR
              • MERIDIAN INDICATOR AM OR A.M. / PM OR P.M.
              • CENTURY INDICATOR CC / SCC
              • NUMERIC WEEK DAY INDICATOR D (1-7)
              • WEEK DAY SPELLING INDICATOR ('DAY')
              • MONTH DAY INDICATOR DD
              • YEAR DAY INDICATOR DDD
              • ABBREVIATED WEEK DAY DY
              • ISO STANDARD YEAR WEEK INDICATOR IW (1-52) & (1-53)
              • ISO STANDARD 4 DIGIT YEAR INDICATOR (IYYY)
              • FOUR DIGIT YEAR INDICATOR YYYY OR SYYY
              • SPELLED YEAR INDICATOR YEAR OR SYEAR
              • NUMERIC MONTH INDICATOR MM
              • WEEK OF THE MONTH INDICATOR W
              • YEAR WEEK INDICATOR WW
              • JULIAN DAY INDICATOR J
              • QUARTER OF THE YEAR INDICATOR Q
              • ABBREVIATED MONTH INDICATOR MON
              • MONTH SPELLING INDICATOR MONTH
              • TWELVE HOUR CLOCK MODE HH OR HH12
              • TWENTY FOUR HOUR CLOCK MODE HH24
              • MINUTES INDICATOR MI
              • ROMAN MONTH INDICATOR RM
              • SECONDS PAST MIDNIGHT SSSS
              • SECONDS INDICATOR SS
          • T0_NUMBER
          • TO_DATE
    • MULTIPLE ROW FUNCTIONS

22. ANSI JOINS

23. HIERARCHICAL QURIES

24. PSUEDO COLUMNS

25. INDEXES

26. DATABASE SECURIY

27. OLAP FEATURES IN ORACLE

28. DATA UPDATING AND DELETION

29. ADVANCED TABLE CREATION STRATEGIES

30. OBJECT ORIENTED CONCEPTS IN ORACLE