Calculating the sum of varchar2 data fields in Oracle 10g.
How to use the sum function of SQL to calculate sum of varchar field. I'm looking for a solution where we cannot use count. ...
oracle10g
Error when multiple users access my web app at the same time
I'm using .Net 2008 and Oracle 10g as my database. The problem I'm getting is after deploying the application in IIS, when multiple users access the same page at a time i'm getting the error. Can't get the output. Note: Both the users accessing the same page, same menu at a time. How can I resolve this? ...
How to see imported Oracle tables
Hello. I have oracle dump file from Oracle8. I am trying to import data in Oracle 10. For importing data I am using PL/SQL Developer(buy the way, I have TOAD client). I am doing that by click Tools->Import Tables choose Oracle Import, and then choose Import file. after that click Ok, Done. so How I can find imported tables? I am using "s...
Oracle Select Query
How can I perform a select operation on two fields and view them as a single field? ex: I have a customer table that holds the customers data, I want to select both last_name and first_name (two different fields) and want to view them like this, "last_name, first_name" using the oracle command not using any language. ...
Reserved word "CLUSTER" used as Column name in Oracle 10g
These is an existing table with column name "CLUSTER". I have to query this table to retrieve values of column "CLUSTER". I am getting missing expression error, since CLUSTER is a reserved word in Oracle. Since oracle has allowed to create a column by name CLUSTER, there should be way to retrieve the same. How can query for this column? ...
Parse SQL via Oracle's JDBC driver
I'd like to test whether given SQL statement is syntactically and semantically valid (ie. no syntax errors and no field misspellings). For most databases Connection.prepareStatement and PreparedStatement.getMetaData would do the trick (no exception == good query). Unfortunately Oracle's newest driver only parses like this only SELECT qu...
SQL Selecting less significant entity from table.
Hi, I have a problem with some query from given result set i need to select the less detail row from table under some conditions. I have three selects that after union return this table SELECT A_ID, B_ID, 1 FROM MY_TABLE JOIN MY_TABLE2 ON SPECIFIC CONDITION FOR LEVEL 1 UNION SELECT A_ID, B_ID, 2 FROM MY_TABLE JOIN MY_TABLE2 ON SPECIFIC...
operations on logging and nologging tables
I have two tables: A is logging, B is nologging. I'm executing on working production environment script like this: begin insert /*+ APPEND*/ into B select * from A; --some kind of direct load insert update A set r=1; end; During execution of above statement there can be transactions which inserts values into A and B tables (normal, co...
Load a structured text data file using only one control file.
I have a text file need to be loaded have structure like this (badly, I don't have permit to change): MM/DD/YYYY 24HH:MI:SS NO_OF_REC EMP_ID,EMPNAME,SALARY ..... Ex: 12/24/2010 20:30:10 number_of_datarow_below E0001,SMITH,5000 E0002,JOHN,7000 E0003,KEWELL,9000 Into one Table: EMP(ISHEADER, HEAD_DATA_TIME, NO_OF_REC, EMP_ID,EMPNAM...
General error: 1 OCIStmtExecute: ORA-00001: unique constraint (HR.SYS_C004023) violated ?
Hi, I can identify the error message that its due to unique value constraint, my table is 'branches',and where did SYS_C004023 come. I have checked the branches table and there is no value duplication. What could be the issue. ...
How to create a trigger to record changes for Insert,Update,Delete for multiple tables.
I have two tables in my Database.This can increase later on.I want to add another table Audit to track changes to the existing two tables.I want to track any change done to any of these table AUdit Table structure is ID Table_Name Field_Name Old_Value New_Value Modified_By Date_of_Modification SO now I want to have one trigger for bot...
appropriate mapping to java type for oracle sequence
hello probably this is a real beginner question, but i cannot find an answer on the web. I have a Oracle db, with a table whose primary key is a NUMBER(16) and is filled with a sequence, whose max value is 999999999999999999999999999 . what java type should i use to hold the sequence value ? long, biginteger or bigdecimal? thank you ...
Find matching strings in table column Oracle 10g
I am trying to search a varchar2 column in a table for matching strings using the value in another column. The column being searched allows free form text and allows words and numbers of different lengths. I want to find a string that is not part of a larger string of text and numbers. Example: 1234a should match "Invoice #1234a" but no...
Whats faster in Oracle? Small table with tree structure vs. Huge flat table.
Hi All. I'm designing an application that will use Oracle, and we have this department hierarchy that we need to map in our database. Some thing that looks like this (I'm pretty sure you all know what I'm talking about but I'll include a piece of the ERD just in case): So it will have data stored that looks like this: [1 | 0] [2 | ...
allround automations pl/sql developer on windows 7 - TNS over IP connect to remote db.
I am really having very hard time making PL/SQL developer PL/SQL Developer work on my windows 7 64-bit OS. I have Oracle 10g standard edition installed already. I tried with PL/SQL developer version 7 and 8 with no luck. Do anyone tried doing it?. Main objective is to just establish a TCP over IP connection to a remote Oracle 10g databas...
peformance efficiency in global temporary tables vs. normal tables - oracle 10g.
I am using large number of global temporary tables for generating huge reports against an Oracle 10g database. Each report consists of 4 to 5 global temporary tables(GTT) per say. But as far as I understand the concept of GTT's, the data is created on the fly per each session for different set of parameters. For example, in my scenario,...
problem in connecting to oracle 10g express edition through java
Hi, I'm unable to connect Oracle 10g database.I am getting exception java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDriver The code is: try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch(ClassNotFoundException e) { e.printStackTrace(); } try { con=DriverManager.getConnection("jdbc:oracle:thin:@local...
asp.net error : Column ambiguously define, when migrate to other server
I have ASP.Net application, It using mix .net framework, there are project with ,net framework 1, 2.0 and 3.5. buat they are in separated project / location. And its running well before. I have a problem when I migrate my application from old development server to new one, FYI, my old server is windows server 2003 32 bit with oracle 10g,...
OC4J server DB persistence - queue message getting retrieved multiple times
Hello, Thanks for trying to help ... We are using oc4j server 10.1.3 and oracle 10g database and using database persistence for the the MDB (EJB 3.0) in the application we have 3 application servers and connected through the load balancer in the production enviornment As we are using database persistence the messages are sending ...
oracle 11g thin jdbc driver compatible with oracle 10g database?
Currently I'm using the ojdbc14.jar Oracle 10g thin driver to access an Oracle 10g database. I would like to upgrade the driver to the thin ojdbc6.jar Oracle 11g driver ahead of the actual upgrade of the DB server occurs. Using an 11g driver against the 10g DB seems fine in testing so far, but I'm wondering if anyone can confirm this O...