Jigar111
April 21st, 2003, 05:50 PM
Hi,
I am getting the following error and I have tried all I can to fix it, but still can't. I am using ORACLE and a java program to do my stuff...
t1 = "CREATE TABLE Lerg6_e1a AS SELECT l_lerg6.npa || l_lerg6.nxx as search, l_lerg6.switch, l_lerg6.sha, l_lerg6.locality, l_lerg6.npa, l_lerg6.nxx, l_lerg6.lata, l_lerg6.lata_name, l_lerg6.loc_state as state, l_lerg6.rc_name as rc_abb, decode(l_lerg6.COC_TYPE = \"EOC\", l_lerg6.switch, ' ') as end_office FROM l_lerg6 where LENGTH(ltrim(rtrim((lerg6.nxx))))= 3 and TO_DATE(SUBSTR(eff_date,1, 2) || \"/\" || SUBSTR(eff_date,3,2) || \"/\" || SUBSTR(eff_date,LENGTH(eff_date)-1, 2), 'MM/DD/YY') <= CURRENT_DATE() "; //group by 1, 2, 3 ";
//System.out.println(t1);
statement.executeUpdate(t1);
I keep getting missing right parenthesis error...Does anyone know why ?
I matched all the parenthesis too....!
I am getting the following error and I have tried all I can to fix it, but still can't. I am using ORACLE and a java program to do my stuff...
t1 = "CREATE TABLE Lerg6_e1a AS SELECT l_lerg6.npa || l_lerg6.nxx as search, l_lerg6.switch, l_lerg6.sha, l_lerg6.locality, l_lerg6.npa, l_lerg6.nxx, l_lerg6.lata, l_lerg6.lata_name, l_lerg6.loc_state as state, l_lerg6.rc_name as rc_abb, decode(l_lerg6.COC_TYPE = \"EOC\", l_lerg6.switch, ' ') as end_office FROM l_lerg6 where LENGTH(ltrim(rtrim((lerg6.nxx))))= 3 and TO_DATE(SUBSTR(eff_date,1, 2) || \"/\" || SUBSTR(eff_date,3,2) || \"/\" || SUBSTR(eff_date,LENGTH(eff_date)-1, 2), 'MM/DD/YY') <= CURRENT_DATE() "; //group by 1, 2, 3 ";
//System.out.println(t1);
statement.executeUpdate(t1);
I keep getting missing right parenthesis error...Does anyone know why ?
I matched all the parenthesis too....!