If you have & or % in your Oracle insert or update statements - you probably would like to do the following:
SQL> set define off
SQL> [your insert or update query containing & and %]
SQL> set define on
Knowledge base on subjects I use in my day-by-day life. Unix, Linux, Mac OS X, VMware, Web, Java, Codfusion, Flex, etc.
If you have & or % in your Oracle insert or update statements - you probably would like to do the following:
Posted by
Unknown
at
11:02 AM
0
comments
Labels: Oracle
Sometimes you need to export result of the query to CSV file. Here is a nice example of how to do this kind of operations.
Posted by
Unknown
at
7:27 PM
2
comments
Labels: Oracle
Apart of modifying /etc/redhat-release to "redhat-4", there are a couple of packages that you will need to install in order to make Oracle 10g work with Cent OS 5.1:
Posted by
Unknown
at
10:12 AM
1 comments