Oracle Help
in [SQL]
|
Java store procedure that reference a external library. Hi. I have this problem. I can to compile a java store procedure that reference a external library. I tested this source in eclipse and execute correctly. I want to copy a file using SFTP from external server to Oracle server. I have loaded the external library "jsch-0.1.37.jar" using javaload, and compiled th... 3 Apr 2008 01:17
Pivot Table Tool Hello, Is there a Windows GUI pivot table tool that has the fuctionallity of pivot tables in Access (user can choose which fields to use in the pivot table, filter the data etc.)? I could of course connect Access to Oracle but this would mean that Access would read a huge amount of data from Oracle and changes i... 2 Apr 2008 10:37
9i: Check- constraint Upper(Column) Hi newsgroup, Is it possible to build a constraint, that ensures, that there are not more entries in a column, that look like 'Abc ' -> trim(upper(..))='ABC' 'ABC' -> trim(upper(..))='ABC' 'aBC ' -> trim(upper(..))='ABC' ? Alternativ I could build a shadow column filled by a trigger that containes ... 7 Apr 2008 04:17
Tool for File-Load via GUI Dear all, is anyone aware of a tool which allows to load flatfiles into an Oracle 9i-DB via a GUI? SQLLDR is great, but since I have to load many files with different structures I appreciate something more efficient... Regards, Andreas ... 2 Apr 2008 07:06
How to "DUMP" a clob? Hello DEFINE _SQLPLUS_RELEASE = "1001000500" DEFINE _O_VERSION = "Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production I have a clob. I save data in it, and then I want to get it back out. I don't always get back what I expect. I would like to examine the "real" data in the ... 2 Apr 2008 08:58
Comparing databases (Oracle, etc.) Dear All, Is anyone aware of a way to compare Oracle databases (schemas and content)? I found a .net software DBTyP.net that promises an easy and visual comparison, but it seems not to be working with Oracle dbs (though their site outlines it as one of the available options). Thank you. Agata ... 2 Apr 2008 13:24
URL encoding with SQL? Hi, I fetch some parameters from a table which I use as GET-Parameter in an URL. Unfortunately there are sometimes special characters like '�', '�', '�' included so I have to url-encode these data during the generation of the URL. Has anybody an idea how I can url-encode a string with an SQL command / fu... 2 Apr 2008 11:11
Oracle BI Training...!!! On 1 apr, 08:51, Datawarehouse Job <dw2...(a)gmail.com> wrote: Hi Dear All, Hope you are doing great. This mail is about Oracle BI (Siebel Analytics) training we provide. We have all setup and experts faculties to provide these kind of training. Please reply back if you have any interest. Yours... 1 Apr 2008 11:46
Static Select statements bigbuck714(a)aol.com wrote: On Mar 28, 3:19�pm, Ubiquitous <web...(a)polaris.net> wrote: Is there a way to force a static row in a SELECT statement? For example, I have a SELECT statement which is a UNION of two identical tables, "A" and "B". How would one create a column which identifies the sourc... 4 Apr 2008 04:10
OCI "ping" function for 10.2? Does anybody know what OCI function this might be calling? If you are using Oracle 10g Release 2 or higher you can use connection.ping() as a way of testing a connection. Its a very low-cost way of testing whether or not the connection is still valid. many TIA! Mark -- Mark Harrison Pixar Animation... 1 Apr 2008 01:39 |