ORACLE: How to escape special characters

We often need to escape special characters while retrieving the rows. To do that there are two ways; Use "SET ESCAPE '{ESC CHAR}' End the select statement with 'ESCAPE '{ESC CHAR}' For example; SELECT SL.SYSTEM_CODE, SL.SYSTEM_DESCRIPTION, SL.SYSTEM_PARTICULARS FROM SYSTEMS_LIBRARY SL WHERE SL.SYSTEM_CODE LIKE 'UOTE\_%' ESCAPE '\' the above statement returns all the systems with system …

Continue reading ORACLE: How to escape special characters

Advertisements

ORACLE: View compiled with errors

Many times when ever we try to create the views under Oracle, often end up with messages like "View created with warnings" or " View compiled with errors". But SQL Developer does not reveal the error. In such cases to know the error actually generated fire the following query in SQL Developed or SQL Plus …

Continue reading ORACLE: View compiled with errors

Windchill: Database Configratation

In the event of disaster recovery, if the database instance name was changed then the Windchill configuration file must be updated with those changes. Following is the way we changed our Windchill configuration; Stop Windchill by issuing "Windchill stop" command at Windchill command prompt. Issue the following commands at windhill prompt Xconfmanager –s wt.pom.jdbc.host=<Host Name …

Continue reading Windchill: Database Configratation

Oracle, Installation issues – Part 1 – Error in invoking target ‘install’ of makefile SomeName.mk

This is one of the common issues that I get during the installation of Oracle on Linux box. Though there are enough resources available to get through this issue, I am just putting them together. I normally get such issue on two files when they are getting processed. ins_emagent.mk ins_ctx.mk ins_emagent.mk, To fix this issue, …

Continue reading Oracle, Installation issues – Part 1 – Error in invoking target ‘install’ of makefile SomeName.mk