Once you get the hang of the CASE WHEN SQL Statement it can be easy to overuse it. Sometimes you do not need to even use the CASE WHEN Statement
Let’s say you have a set of string values (such as values in a column) and you want to remove the last character. But, the string values are all different
Whenever an SQL query has been executed it usually returns the number of rows as well as a short message. Sometimes when working with multiple Stored Procedures, each having multiple
There are several Oracle functions that allow you to convert to a preset data type (TO_DATE, TO_CHAR, TO_NUMBER). There’s also a function that allows you to specify the data type.
If you ever want to add a number of months to a date in Oracle SQL, you can use the ADD_MONTHS function. It’s a simple function and takes two parameters???a
In Oracle, constraints can be set up to enforce business rules on a database. Sometimes you might want to remove constraints. To do this, use the ALTER TABLE command. ALTER
Did you know that SQL has built-in JSON functions? These can come in very handy! Instead of creating a very complicated query that exports XML and then translate it to
If you need to find the source code for a function or procedure in the database, it’s easy to do in Oracle. You can query the all_source view to get
You may not know this but you can have optional Parameters in SQL. It took me forever to figure it out. In any case, you can implement an optional parameter