Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1951

Oracle PL/SQL | Programming in Simple Steps

Show all headers | View raw

Enhance the capabilities of SQL as PL/SQL allows mixing of SQL statements with procedural constructs. Unlike SQL, PL/SQL is a programming language extending SQL, which includes procedural elements like loops, data types, control structures and others. You can create program blocks, functions, methods, triggers and packages with this extension. In simple terms, while SQL tells the relational database what to do, PL/SQL tells them how to do.

The main sections on language PL/SQL are:
1. DML Statements
2. Select Query
3. Table Joins
4. Stored Procedures
5. Functions
6. Collections and Records
7. Cursors
8. Exception Handling
9. Triggers
10. Views
11. Error Messages

Start learning Oracle PL/SQL from basics to advance levels here...
https://goo.gl/KMSUDC

Back to comp.databases.ms-sqlserver | Previous | Next | Find similar

Thread

Oracle PL/SQL | Programming in Simple Steps anitagoyal571@gmail.com - 2016-02-05 10:16 -0800

csiph-web