Black and white Computer

When try to connect to the local database , you found this message : Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor I consider this as error ORA-1250. In my case ,to solve this problem you need to change the SID " xe " to " e161306 " then the problem solved! Then the question come when you try, you may be fail because the SID for mine may differ from yours! If you have dint change the Connection name , then you will see that there will be some word behind the dash '-', you should key in the word behind into the SID. Like mine is 'e161306'. How to know your SID? I think it was quite easy! All you need is open your msconfig if you are using Microsoft windows Operating System. Start --> run-->type in "msconfig"/ Start --> type in msconfig--> click msconfig.exe After you open the msconfig, yo...

Recently, I use the SQL statement like this   INSERT INTO Table_Name VALUES(12-JUN-97);  But it give me a error description about the missing column , and error code of . My syntax/statements are1 not short as above , but since others data type is VARCHAR2 and NUMBER thus I can quickly identify the problem come from the DATE . Then, I Google and found that many others people also face the problem on the same error code, may be your error is not similar with me but I would like to share solution on the problem I have faced for almost half hour that can be solve in few minute. Hope that people that have same problem like me can solve it once see my post. The error can be easily fixed by adding '12-JUN-97 '  into the date instead of 12-JUN-97 . Another problem face by my friend is the date format of the ORACLE SQL DEVELOPER is not as the 12-JUN-97. So to change the time format you can follow the instruction below and have ...

Oracle SQL Developer is a free integrated development environment that simplifies the development and management of Oracle Database. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.SQL Developer can connect to any Oracle Database version 10g and later and runs on Windows, Linux and Mac OSX. Oracle SQL developer cannot stand alone it should accompany with database syst...