A Dev Gym Workout

How Good Are You at PL/SQL?


In this workout, Steven Feuerstein gathered quizzes from the Dev Gym library covering many topics in PL/SQL. The idea is to take one workout and get an overall sense of your level of familiarity with and expertise in PL/SQL.

  • Instructor

    Steven Feuerstein*

  • Estimated Time

    105 Minutes

  • Difficulty

    Beginner to Advanced

Take Workout

Oracle Account Text

You need an Oracle Account to take a workout. Click here to sign up.
Already a member of the Oracle Dev Gym? Click here to get back to work.

Exercises

Exercise Difficulty Time
Quiz on Case ExpressionsIntermediate6
Quiz on Loops in PL/SQLIntermediate2
Quiz on Cursor FOR LoopsIntermediate2
Quiz on The WHILE-LOOP StatementIntermediate6
Quiz on SUBSTRBeginner2
Quiz on Negative Start Location in SUBSTRIntermediate7
Quiz on TRANSLATEIntermediate2
Quiz on Exceptions Raised in Declaration SectionIntermediate2
Quiz on RAISE_APPLICATION_ERRORIntermediate6
Quiz on OverloadingBeginner7
Quiz on Table FunctionsIntermediate2
Quiz on Dynamic SQLAdvanced2
Quiz on Repeating Placeholder Names in Dynamic SQL StatementsAdvanced21
Quiz on Autonomous TransactionsIntermediate6
Quiz on CURRENT OF ClauseIntermediate5
Quiz on RETURNING Column Values from DML StatementsIntermediate6
Quiz on Impact of Exception on Completed DML StatementsIntermediate6
Quiz on Fetching a Single RowBeginner2
Quiz on Bulk Processing with FORALL and BULK COLLECTIntermediate2
Quiz on Bulk-Fetching from a Cursor Into One Collection of RecordsIntermediate7
Quiz on Sparse Bind Arrays in FORALLIntermediate2
Quiz on Package-Level DataIntermediate2
Quiz on Scope of package-level cursorsIntermediate2
Take Workout
Instructor

*About Steven Feuerstein

Steven Feuerstein is a Senior Advisor at Insum Solutions (https://insum.ca), and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). You will find an abundance of quizzes from Steven at the Dev Gym. Enjoy!

More from Steven Feuerstein