Oracle Database Tutorials

PL/SQL Tutorials for Beginners

PL/SQL Tutorial list

PL/SQL Tutorial 81:- Execute Immediate with INTO clause

Native dynamic SQL or NDS is helping developers by providing flexibility, improving performance and simplifying programming syntaxes. Today in this tutorial we are going to learn how to write a Dynamic SQL query in Oracle Database using Execute Immediate Statement.

PL/SQL Tutorial 82:- How to run Create Table DDL with EXECUTE IMMEDIATE in Oracle Database?

You must be thinking that what could be the trouble in executing a CREATE TABLE DDL? Right, no trouble as long as you are executing them with SQL, but when it comes to executing them ...

PL/SQL Tutorial 83:- Create Table DDL with EXECUTE IMMEDIATE Part 2

There are two ways of writing a DDL query for Execute Immediate statement of Native Dynamic SQL in Oracle Database. We have already discussed one of them in the last tutorial. The first way which we discussed in the previous tutorial is probably the easiest way of writing a SQL query for Dynamic SQL but that doesn’t stop us from learning further.

PL/SQL Tutorial 84:- Alter and Drop DDL with EXECUTE IMMEDIATE

As of now, we have learnt all the possible ways of creating a table right inside a PL/SQL block using Native Dynamic SQL

PL/SQL Tutorial 85:- Insert DML with Bind Variable by applying Using Clause of Execute Immediate

Will it not be an icing on the cake if we could figure out a way to use Bind Variables with Native Dynamic SQL? If you are wondering so then my dear friends you are at the right place as we are going to do exactly that in this blog.

PL/SQL Tutorial 86:- Multiple Bind Variables with Execute Immediate of Dynamic SQL

Chances of using multiple bind variables in a project are much higher. Thus in today’s PL/SQL tutorial you will be learning how to use multiple bind variables with Execute Immediate of Native dynamic SQL.

PL/SQL Tutorial 87:- Bulk Collect Into clause with Execute Immediate of dynamic SQL

Wouldn’t it be amazing if we could minimize the performance bottleneck caused by context switches and optimize our dynamic SQL query. We already know that we can easily control the context switches through the use of bulk data processing.

PL/SQL Tutorial 88:- PL/SQL Block with Execute Immediate of dynamic SQL

In the last couple of weeks we have learnt a lot about dynamic SQL now I think it’s time to move on to dynamic PL/SQL.

  • Manish Sharma Oracle Rebellion Rider
  • Manish Sharma Oracle certified SQL expert
  • Manish Sharma oracle certified associate
  • Manish Sharma oracle certified professional
  • View Manish Sharma's profile on LinkedIn

         View Manish Sharma's profile on LinkedIn