Oracle Database 11g: SQL and PL/SQL New Features 1 - 195
{"Image DocumentName": "Oracle Database 11g: SQL and PL/SQL New Features", "Image ImageDescription": "Summary. In this lesson, you should have learned how to: Implement the sequence calls to NEXTVAL and CURRVAL without using a SQL statement to retrieve the values. Use the new CONTINUE statement to control the next loop iteration or to leave a loop. Use both named and mixed notation calls to functions from a SQL statement. Use the ALTER TABLE statement to change tables to read-only status. Summary. In this lesson, you learned about a variety of topics pertaining to SQL and PL/SQL language usability. Sequences are easier to use in PL/SQL. PL/SQL has a new CONTINUE statement to help you control loop logic. You can use named, positional, and a mix of the two calls when accessing functions from a SQL statement. The ALTER TABLE syntax now lets you change your tables to read-only status and then change them back to read/write status. Oracle Database 11g: SQL and PL/SQL New Features", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}