I have a COM+ application开发者_开发问答 (mostly vb6 based), that I need running on a 64-bit system. It\'s supposed to communicate with an oracle database (10g, 32bit). Everything works fine when I di
I have the test.sql script which is called from unix shell script test.sh.Problem is in test.sql script when i have a exception i do the rollback and exit. When it comes to shell script it will have e
I 开发者_StackOverflow中文版have a query which returns the result set as follows: Col1 A B C D Is it possible to get the following result set? That is associating a value to remaining 3 row values?
I\'m trying to perform something in Oracle/PLSQL where I want to select some stuff from the db via a cursor and store it into an array of rows, which I can later process. Searched on google but to no
Sometimes I get a dash in output but I was told it\'s not a null, so what is it? select title, order#, STATE
I\'ve seen some examples in which decimal is used in NHibernate projects for mapping to whole number columns in Oracle. Right now I\'m using int and long in my program.
Oracle 10g is the db. The below query fails when extracting the date. SELECTTO_CHAR ( TO_DATE ( SUBSTR (file_name , INSTR (file_name , \'_\', -1, 2)+ 2, 8), \'YYYYMMDD\'), \'开发者_JS百科DD-MM-YYYY
I am using Oracle 10g. My Java program gets some files having huge text contents + images. I want to Store Data (having text files with Images) in oracle. What is the best way to to insert and retri
I am looking for something like this: http://www.codeproject.com/KB/database/SQL_Server_2005_Database.aspx
I have written a connection code with oracle. But still I am getting errors.I\'ll type the code of mine here.