I am trying to figure out what is the best way to connect an (existing) ASP.Net application to an Oracle database to read its dictionary information. There are simply too many possibilities: MS Data Provider for Oracle (requires 8.1.7, namespace System.Data.OracleClient) Oracle Data Provider for .NET (requires 9.2, namespace Oracle.Da...
Where can I find a good comparison between SQL server and Oracle? (Note the original question referred to "...types...function...". Perhaps the original asker could clarify what was meant.) ...
Oracle's instructions specify setting DYLD_LIBRARY_PATH. This makes my application dependent on random users' configuration and is very troublesome to set up. How can I avoid having to set any environment variables? http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/intel_macsoft.html related note for linux: http...
Is it possible to read/write data from/to a file in a PL/SQL block without using the UTL_FILE package in Oracle 10g? I currently have a file containing a set of primary keys (approx. 28000) that I need query a table for additional data that needs to be written out to a file. The schema I am using is very restricted and do not have any c...
Hi All, Can anyone show me the step of restore and recovery of below scenario? I have used the differential backup (cumulative) everyday. RUN { RECOVER COPY OF DATABASE WITH TAG "whole_database_copy"; BACKUP INCREMENTAL LEVEL 1 CUMULATIVE FOR RECOVER OF COPY WITH TAG "whole_database_copy" DATABASE; } I have copies of all datafi...
I have 2 Oracle questions How do I translate this SQL Server statement to work on Oracle? Create table MyCount(Line int identity(1,1)) What is the equivalent of SQL Servers Image type for storing pictures in an Orace database? ...
Anybody knows how to do this? I know there's a better way of loading XML data to Oracle without using SQL*Loader, but I'm just curious on how this is done using it. I have already a code that can load XML data to the DB, however, it wont run if the XML file has values that contain a CDATA... Below is the control file code which works ...
Are the Oracle ODP.NET libraries redistributable? As in, can I simply include the Oracle.DataAccess.dll with my application & reference it without getting into any legal hot water? The download license for the ODAC on OTN is fairly incomprehesible legalese that doesn't make it clear whether I can or can't include the dll directly. ...
Hi, I'm changing a database (oracle) with a script containing a few updates looking like: UPDATE customer SET status = REPLACE(status, 'X_Y', 'xy') WHERE status LIKE '%X_Y%' AND category_id IN (SELECT id FROM category WHERE code = 'ABC'); UPDATE customer SET status = REPLACE(status, 'X_Z', 'xz') WHERE status LIKE '%X_...
I have a batch of sql statements such as ... insert into.... ; insert into.... ; delete .........; etc When i try to execute them against oracle it gives me this error (ORA-00911 Invalid Character) now i can understand that this is because of the semicolon between the statements, i tried this on SQL Server and it worked but in Oracle...
I'm still learning some of the PL/SQL differences, so this may be an easy question, but... here goes. I have a cursor which grabs a bunch of records with multiple fields. I then run two separate SELECT statements in a LOOP from the cursor results to grab some distances and calculate those distances. These work perfectly. When I go to u...
I have an entire DB to be imported as a dump into my own. I want to exclude data out of certain tables(mostly because they are huge in size and not useful). I cannot entirely exclude those tables since I need the table object per se(minus the data) and will have to re create them in my schema if I do so. Also in the absence of those tab...
Hi, Imagine I have a database with one table, this table has only one field named "word" and some other data, imagine also that user can search data by typing contents of this field. I have a lot of words on this table with Spanish accents. Word examples ácido autobús camión Question If user searches for "acido" or "ácido" words t...
Oracle pads values in char columns so if I insert "a" in a CHAR(2) column then I cannot get that record by comparing that column to "a", I should get it by comparing it to "a ". Right? To solve this problem the Oracle jdbc driver has the property fixedString but I cannot make it work. (look for fixedString here) I'm using ojdbc14.jar d...
We have about 10K rows in a table. We want to have a form where we have a select drop down that contains distinct values of a given column in this table. We have an index on the column in question. To increase performance I created a little cache table that contains the distinct values so we didn't need to do a select distinct field...
Is there a function built into Oracle that will return the highest possible date that may be inserted into a date field? ...
I would like to generate view CUSTOMER, CUSTOMER_ID, PRODUCTS ABC INC 1 A=XYX, B=ZZZ DEF CO 2 A=XYX, B=ZZZ, C=WWW GHI LLC 3 B=ZYX Would like the view to be something like CUSTOMER, CUSTOMER_ID, A B C ABC INC 1 XYX ZZZ DEF CO 2 XYX ZZZ WWW GHI LLC 3 ...
Is it possible to dynamically reference the :NEW/OLD pseudo records, or copy them? I'm doing a audit trigger for a very wide table, so would like to avoid having separate triggers for insert/delete/update. When updating/inserting I want to record the :NEW values in the audit table, when deleting I want to record the :OLD values. ...
I am new in oracle ERP BOM, and I'm reading oracle BOM user guide now, if there are some resource I can reach for help and deep understanding about it? ps: I want to be a professional and not just know how to config oracle. ...
Suppose I have two tables, t1 and t2 which are identical in layout but which may contain different data. What's the best way to diff these two tables? ...