While doing some testing of Oracle on a Windows 7 computer I stopped the TNS Listener service also known as OracleOraDb11g_home1TNSListener. The problem is when I attempted to restart the service it would not start. While testing various other things I had made numerous changes so I started looking into what might cause the issue…
Again I am fairly new to Oracle so it has been quite a learning process and typically I have been running into errors that are easy to resolve but being able to locate the answers easy has been challenging. While attempting to use sqlplus.exe from the Windows 7 command line I continued to receive a…
I recently installed Oracle on a Windows 7 computer to test some tools that are available in Backtrack. I am very new to Oracle so it has been a bit of a learning process including the fact that I had no idea you can install Oracle without having to pay any money to download it…
Troel has written a great summary of the SQL standard for the timestamp data type along with its implementation in the big 5 databases (MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and DB2). MySQL It turns out that MySQL does not support sub-second time or date formats. There is a MICROSECOND function in MySQL allowed to…