Fraud Blocker

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

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

Thank you, the form has been submitted.