Useful tips for everyday
What is a serial data type? The SERIAL data type stores a sequential integer, of the INT data type, that is automatically assigned by the…
What is the correct function to get the combined results of two queries? The Union operator combines the results of two or more queries into…
How do I find my Oracle 11g port number? Locate Oracle Listener Port You find out the Oracle listener port number from listener.ora file. In…
Does Oracle support DDL transactions? Oracle Database Oracle does not support transactional DDL: the transaction is considered as closed when CREATE, DROP, RENAME or ALTER…
What is the difference between startup mount and startup Nomount? Startup mount: Mount the database and open the control file. The Nomount mode has not…
What is a harmonization number? A Harmonization Number is a specific designation that the international mailing system assigns to products, so they can keep records…
What should I delete if my C: drive is full? Right-click on C: drive and select Properties, and then click “Disk Cleanup” button in the…
How can I tell when SQL Server restarts? To view the error log using SQL Server Management Studio, Open SSMS Connect to SQL Server instance…
How can I see all Dblinks in Oracle? Any user can query USER_DB_LINKS to determine which database links are available to that user. Only those…
How do I refresh IntelliSense? Database Engine Query IntelliSense Select the Edit menu, select IntelliSense, then select Refresh Local Cache. Use the CTRL+Shift+R keyboard shortcut.…