Fraud Blocker

Oracle LENGTH function

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

Continue Reading

Oracle INSTRB function

The Oracle/PLSQL INSTRB function returns substring occurrence in a string, bytes instead of characters….

Continue Reading

TRANSFER PGAGENT SCHEDULED JOBS TO PG TIMETABLE 

Why go from pgAgent to pgTimetable?
Actually, there are numerous justifications for why someone would wish to export pgAgent jobs to a pg timetable. T…

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

Oracle LPAD function

The Oracle/PLSQL LPAD function adds a certain set of characters from the left side of the string (at non-zero string1)….

Continue Reading

🎉 Thank you for subscribing!

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