A comparison between static SQL vs dynamic SQL shows us pretty clearly that, if there exists a choice, we are better off choosing static SQL.
So, when should we use dynamic SQL?
{ 0 comments }
dynamic SQL
Some questions do not have definitive answers. "Is a full table scan bad? Should this design be denormalized? Will partitioning this table help?" The answers vary widely depending on the specifics on the problem.
Fortunately, "Should I use static SQL or dynamic SQL?" is not one of those questions.
{ 0 comments }
When you need to find out if a specific element exists in a collection or not, how do you go about it? Do you loop through the list till you find the value?
If that’s what you do, this post is for you.
{ 2 comments }
How will you find out the number of rows in each table in a schema in Oracle?
Here are two approaches with their pros and cons.
{ 0 comments }
Oracle does not a have ready-made command to restart a sequence. There is no direct way to do this:
alter sequence test_seq restart with 0;
But I have a simple workaround to share with you. This article gives you a script to restart a sequence, explains how it works and shows you a test run with a sample sequence.
{ 9 comments }
