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.
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 ...
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.
As of now, we have learnt all the possible ways of creating a table right inside a PL/SQL block using Native Dynamic SQL
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.
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.
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.
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.