Search results for query: *

Hi, I have two tables (TABLE1 and TABLE2) and they have 3 columns that are the unique key in each. These unique columns are the same in each table. My question/issue is how to get the records in TABLE1 NOT IN TABLE2??? I did a manual check and I know there are 2 records in TABLE1 not in...

Hi, I'm getting the Field in data file exceeds maximum length. Is there some limit that I'm unaware of??? The column it is failing on is VARCHAR2(4000). The data file is pipe delimited and the file it is failing on is only 260 characters??? I'm confused on why I'm getting this error... has...

Hi, I have a data file like the following: BEGIN 1ST FILE| 1|2|3|4|5 6|7|8|9|10 END 1ST FILE| BEGIN 2ND FILE| A|B|C|D|E F|G|H|I|J END 2ND FILE| BEGIN 3RD FILE| .....ETC.... Is there a way to extract the data just for the 1ST File and then 2ND File and etc...? I need to ouput the 1ST FILE to...

Hi, I have a table that has the following: LEVEL_ID CHAR(2) LEVEL_DESC_TX VARCHAR2(240) LEVEL_CAT_TX VARCHAR2(240) The data file contains a pipe delimited file: 1|FIRST LEVEL| 2|SECOND LEVEL| 3|THIRD LEVEL| ...etc... The LEVEL_CAT_TX field, I need to merge the contents of the...

Oracle 8i Hi, I have an issue on how to extract data from a single table that stores the data for different levels of a Hierarchy in the same columns. Here's an example: PARENT_VALUE CHILD_VALUE 100 200 100 300 200 ABC 200 DEF 300 ZZZ...

Hi, I have a data file (input_file.dat): BEGIN DATA EXTRACT 1|AUG-05|10002|2260388115.38|-4151079.23|2256237036.15|0|0 1|SEP-05|10002|2256237036.15|-4612568.24|2251624467.91|0|0 1|AUG-05|10002|1843860115.32|61745489.54|1905605604.86|0|0 1|SEP-05|10002|-488569233.24|0|-488569233.24|0|0 END DATA...

Hi, I have a data file that contains Control Characters: A|TEST^M B|TESTING^M ...etc... Is there a way to remove the Control Characters in the data file via a ksh unix script? Thanks for your time.

Hi, In PL/SQL, the & is used to a variable holder. So, if you tried to make a variable like: test_tx := 'Test one & two'; it asks for the value of two when trying to execute the code. Is there a way to make PL/SQL accept the text as is? So, basically ignoring the & so that the text keeps...

Hi, I have a file: 10001|100.00|SOURCE1| 10001|100.00|SOURCE2| 10002|500.00|SOURCE1| 10002|1000.00|SOURCE2| I need to compare the lines by reading them one by one and seeing if they differ in the amount fields by using the primary key as the uniqueness (first column). The SOURCE1 and SOURCE2...

Oracle 8.1.7.4 I have two different character strings to get a hash key and I'm using the max which is 2 to the power of 30 (1073741824) select dbms_utility.get_hash_value(RTRIM('7235')||RTRIM('10041')||RTRIM('BS')||RTRIM('Cash & Cash Equivalents'),1,1073741824) FROM DUAL select...

Hi, I need to be able to create a cursor for a select statement so that I can process each record one by one. Here are the catches: * The Select statement is not hardcoded since it is dynamic. So, I do not know the tables or columns to be used. Is there a way? Thanks [dazed]

Hi, I have a table that contains 19 million rows. I need to update 14 million of them to change a value from NULL to 0. Is there a quick way to do this? TABLE PK COLUMN 1 PK COLUMN 2 PK COLUMN 3 PK COLUMN 4 PK COLUMN 5 COLUMN A COLUMN B COLUMN C COLUMN D (YEAR) COLUMN E (MONTH) I need to...

Hello, I have a data file like below: Currency Code |Currency Description | CAD |Canadian Dollars | USD |US Dollars | I have the option to skip=1 to ignore the header record and I have it terminated by |. The issue is the tab character after the value. Is there a way to remove it? I know I...

Hello All, Does anyone know how to add a single quote to a varchar2 variable? I'm bascially creating a dynamic INSERT statement by using variables. The problem is that the column is varchar2 and needs single quotes around the value. So, when I'm creating my INSERT statement, I have to use...

I have an interesting situation that I do not know if it is possible to be done or not. I have a pl/sql script (code) that when it is called by any user, I need to capture their information (i.e. User Id) so that I can store it in a log table. I know in my pl/sql I can insert a record into the...

Hello, I have a dynamically created select statement and store it in VARCHAR2 variable. Now, I need to open and execute it to fetch the values. DECLARE ... TYPE cv_type IS REF CURSOR; TEST_CURSOR cv_type; ... BEGIN ... OPEN TEST_CURSOR FOR v_select_string; I'm good to here but I have not...

Hi, Does anybody know anything about Hash Keys on tables? I need to figure out when I join to a table that contains one, to capture the hash key value. Oracle refers to a hash function to get that information but I have not found it yet. [dazed]

Good Afternoon, I have a situation for a requirement which I do not know if it can be done. I have been on google for hours trying to find a document/help on it so I thought I would give this a try. If I have a Fact Source Table i.e. TABLE Account_Table Account # Date Amount Due We want to...

Hello, I was curious if PL/SQL can read in XML files and process the information. The version of Oracle is 8.1.7.4 If not, is there a work-around? Thanks for you time

Hello, I have a situation and wondering if anyone can help me. I currently have Websphere v4.0 installed on Windows 2000. I have an application that uses java JDK v1.3 and tomcat v4.1. I have been given the task to see if this tomcat application can be put into Websphere... This will...