Hi all, I was wondering if there was a way to tell if an instance of Oracle on a system has a database installed or not? This is for an installation script, and I need to verify that there is an actual database in place before proceeding with the loading of my own tablespace onto that database. Has anyone tackled this problem before? ...
Hi, I have seen that there is a NVL function for P/SQL that substitutes a value when null is encountered. But what if I want to set a field to NULL, e.g. EXEC SQL UPDATE mytable SET myfield=NULL WHERE otherValue=1; When I run this with C++ on HPUX, 0L is used for null while on Linux the statement fails with "illegal value". Is there a...
Hi , Excuting the line of SQL: SELECT * INTO assignment_20081120 FROM assignment ; against a database in oracle to back up a table called assignment gives me the following ORACLE error: ORA-00905: Missing keyword ...
The program that I am currently assigned to has a requirement that I copy the contents of a table to a backup table, prior to the real processing. During code review, a coworker pointed out that INSERT INTO BACKUP_TABLE SELECT * FROM PRIMARY_TABLE is unduly risky, as it is possible for the tables to have different columns, and differ...
Hi all, how can i import data from an oracle database to a mysql database by using CTL file (generate with Toad for oracle)? Thank in advance Andrea ...
Hi, I am using ASP.NET 2.0 and VS 2005. I need to populate a grid on an update panel from an Oracle refcursor after the user clicks a button. I have an example from another project, but it is pretty complicated. Is there an easy way to display the data in a grid in an updatepanel? We don't want the data to be displayed when the tab...
Hi, I have a fairly huge database with a master table with a single column GUID (custom GUID like algorithm) as primary key, and 8 child tables that have foreign key relationships with this GUID column. All the tables have approximately 3-8 million records. None of these tables have any BLOB/CLOB/TEXT or any other fancy data types j...
A table exists that someone else loaded. I need to query against the table, but the lack of indexes makes the query plan abysmal. What I would like to do is detect if there is an index for a particular column, so that I can created it if it does not exist, and not create it if it is already there. Thanks. Evil ...
I am able to create and execute a DTS package that copies tables from a remote Oracle database to a local SQL server, but want to setup the connection to the Oracle database as a linked server. The DTS package currently uses the Microsoft OLE DB Provider for Oracle with the following properties: Data Source: SERVER=(DESCRIPTION=(ADDRE...
What column type in Oracle 10g can be used to store any value of java double up to and including Double.MAX_VALUE and Double.MIN_VALUE? ...
I've got a dbms_scheduler-Job running in Oracle 10.2.0. When I change the system date back to yesterday, the job will wait for one day to continue its work. The reason for this is that next_run_date does not change. This does not happen regularly, but sometimes someone decides to change the system date without thinking or even knowing ...
I need to transform an Oracle SQL statement into a Stored Procedure therefore users with less privileges can access certain data field: SELECT info_field, data_field FROM table_one WHERE some_id = '<id>' -- I need this <id> to be the procedure's parameter UNION ALL SELECT info_field, data_field FROM table_two WHERE ...
Hi, Until recently we used Oracle sequences to generate the IDs of a table. This is now changed, a new ID is now calculated by an Oracle function. Which means that my application needs a change to adept to the new situation. The application is a Spring/Hibernate webApp, which access the Oracle database. This was configured in an hbm.xml...
What is the proper way to split up SQL statements to send to an Oracle ADO.NET client? For instance, lets say you have the following code in a text file and want to execute these statements: CREATE TABLE foo (bar VARCHAR2(100)); INSERT INTO foo (bar) VALUES('one'); INSERT INTO foo (bar) VALUES('two'); I believe trying to send all tho...
Hi, I'm using Oracle 10g and I'm trying to "stack" the conditions in a CASE statement, like I would do in C++ : case 1: case 2: // instructions break; i.e. having the same code block executed for two different successful conditions. I've tried : WHEN 1, 2 THEN WHEN 1 OR 2 THEN ... without luck. Is it even possible ? Than...
I have made a small project in Oracle, by using the oracle forms builder - how do I create an installer (setup.exe) for my project (one that would setup the application on MS Windows?) Please... help me, and thanks a lot ...
I am using Oracle BPEL Process manager and have a task assigned to a group of users. I try to mark it approved using Java class oracle.bpel.services.workflow.task.ITaskService.updateTaskOutcome(). This works if the task is assigned to an individual user, but if the task is assigned to a group of users, I get an error message about the t...
I have two tables: a source table and a target table. The target table will have a subset of the columns of the source table. I need to update a single column in the target table by joining with the source table based on another column. The update statement is as follows: UPDATE target_table tt SET special_id = ( SELECT source_specia...
Greetings, My company uses Peoplesoft for its financials and HR. Our implementation is on Oracle databases. Setting global_names = TRUE forces you to name your database link the same as the target. My question is does anyone know the ramification of setting global_names to false in the init.ora parameter file? More specifically, I...
How can I find poor performing SQL queries in Oracle? Oracle maintains statistics on shared SQL area and contains one row per SQL string(v$sqlarea). But how can we identify which one of them are badly performing? ...