How To Use Oracle NVL
This tutorial page is based on simple examples to make it easier to follow. Function Oracle NVL allows to replace empty (null) …
How To Use Oracle Date Format
This tutorial page is based on examples to make it easier to follow. Oracle Date Format types are on this link. The …
How To Write UPDATE Statement In Oracle
This tutorial page is based on examples to make it easier to follow. Statement Oracle UPDATE allows to amend the data in …
How To Use TO_CHAR In Oracle
This online tutorial is based on examples to make it easier to follow. Function Oracle TO_CHAR converts values like NCHAR, NVARCHAR2, CLOB, NCLOB, …
ORA-01031: Insufficient Privileges With Oracle Shutdown
Our Oracle DBA has found an oracle database management bug shutdown commands raising error ORA-01031: insufficient privileges. Let play through the most common way …
Error ORA-12170: TNS:Connect timeout occurred
Error ORA-12170: TNS:Connect timeout occurred can have many different reasons as one of them could be that Oracle database connection is defined …
How To Use Oracle Expdp Utility
This online tutorial is based on examples to make it easier to follow. Utility oracle expdp (Oracle Data Pump Export) is moving …
How To Use DECODE in Oracle
This tutorial page is based on examples to make it easier to follow. Oracle DECODE allows to compare the input value with …
How To Use Oracle INSTR Function
This online tutorial is based on examples to be easier to follow. Functions Oracle INSTR ,INSTRB , INSTRC , INSTR2 , INSTR4 …
How To Find in Oracle DATE Difference
This online tutorial is based on examples to make it easier to follow. The Oracle Date type can be used to do …