Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
3 Cards in this Set
- Front
- Back
|
What is procedural extention to SQL? |
Programming constructs that enables the use of procedural programming language functionalities, such as flow-of-control. |
|
|
What are the advantages of PL/SQL? |
1. Saves network traffic 2. Multiple SQL statements can be executed with a single call 3. It is alright compiled, hence saves parsing overhead |
|
|
What are the major extentions? |
1. Variables 2. Block structure 3. Control structure (LOOP, EXIT, IF..ELSEIF..ELSE) 4. Arrays 5. Functions |
