Fraud Blocker

Oracle INSTR function.

The Oracle/PLSQL INSTR function returns the n-th occurrence of a substring in a string….

Continue Reading

Oracle INITCAP function

The Oracle/PLSQL INITCAP function sets the first character of each word in upper case, and the rest in lower case….

Continue Reading

Oracle INSTR2 function

The Oracle/PLSQL INSTR2 function returns substring occurrence in a string using UCS2 code points….

Continue Reading

Oracle LENGTH function

The Oracle/PLSQL LENGTH function returns the length of the specified string….

Continue Reading

FROM CLAUSE ALIASES, SUB-SELECTS IN 

What do SQL aliases mean?
A temporary name for a result set is given using SQL aliases in FROM clauses. A table or view name, sub-SELECT, and/or VALUE…

Continue Reading

🎉 Thank you for subscribing!

You're now on the list for database FinOps strategies and performance insights.