At the first time startup of SQL developer, you may want to new a connection to start to use the tool. But sometimes, you might… Read More »SQL Developer No TNS ?
DBA Role In Oracle database, DBA could be the most privileged role. Whenever we want to make a user to be the most dominant application… Read More »DBA Role, How and Why
TO_CHAR is an overloading function which converts or extracts various types of input values into desired or readable output. TO_CHAR for Datetime TO_CHAR for Number… Read More »Oracle TO_CHAR Example
Timings to Restore SPFILE At several occasions listed below, you may need to restore it from a previously backed up SPFILE. SPFILE was accidentally deleted.… Read More »How to Restore SPFILE
Timings to Backup SPFILE In case that we need to restore SPFILE to the original state at a later time, we should backup SPFILE in… Read More »How to Backup SPFILE