skip to main | skip to sidebar

Monday, July 14, 2008

34. PL/SQL SYLLABUS

techonthenet.com

Oracle is a relational database technology.

PLSQL stands for "Procedural Language extensions to SQL", and can be used in Oracle databases. PLSQL is closely integrated into the SQL language, yet it adds programming constructs that are not native to SQL.

We've categorized Oracle and PLSQL into the following topics:

Data Types SELECT Statement
Literals (Constants) DISTINCT
Declaring Variables COUNT / SUM / MIN / MAX
Is Null / Is Not Null

WHERE Clause
Loops and Conditional Statements "AND" Condition
Sequences (Autonumber) "OR" Condition
Transactions Combining "AND" with "OR"
Cursors
Functions (Built-In) (By Category) "LIKE" Condition
Functions (Built-In) (Alphabetical) "IN" Function
Oracle System Tables BETWEEN Condition

EXISTS Condition
Primary Keys GROUP BY
Foreign Keys HAVING
Unique Constraints ORDER BY (sort by)
Check Constraints
Indexes JOINS (inner, outer)

Subqueries
Creating Functions
Creating Procedures UNION Query
Creating Triggers UNION ALL Query
Exception Handling INTERSECT Query
Oracle Error Messages MINUS Query


Grant/Revoke Privileges UPDATE Statement
Roles (set of privileges) INSERT Statement
Change Password DELETE Statement


Synonyms (create, drop) Tables (create, alter, drop, temp)

Views
Posted by veerendra at 3:29 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

veerendra

Blog Archive

  • ▼  2008 (45)
    • ►  August (6)
    • ▼  July (30)
      • 40. Final Nav
      • 39. DWH Nav Steps
      • 38. ETL Concepts
      • 37. Diagram of ETL
      • 36. ETL Concepts
      • 35. INFORMATICA FAQ'S
      • 34. PL/SQL SYLLABUS
      • 33. SQL Syllabus on net
      • 32. SQL TUTORIAL
      • 31. SQL QUERIES
      • 30. CREATE VIEW
      • 29. SELECT INTO
      • 28. GROUP BY
      • 27. FUNCTIONS
      • 26. ALTER
      • 25. DROP
      • 24. CREATE
      • 23. UNION
      • 22. JOINS
      • 21. ALIASES
      • 20. BETWEEN
      • 19. IN
      • 18. AND/OR
      • 17. ORDER BY
      • 16. DELETE
      • 15. UPDATE
      • 14. INSERT INTO
      • 13. WHERE CLAUSE
      • 12. SELECT STATEMENT
      • 11. SQL Syntaxes
    • ►  June (9)

About Me

veerendra
View my complete profile