Oracle PL/SQL | Programming in Simple Steps.
From: <anitagoyal571_at_gmail.com>
Date: Fri, 5 Feb 2016 09:41:19 -0800 (PST)
Message-ID: <43771fce-a2da-4a0a-b1f3-c2f263072890_at_googlegroups.com>
This enhanced 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.
10. Views
11. Error Messages
Date: Fri, 5 Feb 2016 09:41:19 -0800 (PST)
Message-ID: <43771fce-a2da-4a0a-b1f3-c2f263072890_at_googlegroups.com>
This enhanced 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 R Programming from basics to advance levels here...
https://goo.gl/KMSUDC Received on Fri Feb 05 2016 - 18:41:19 CET