Prod Database============10g with AL32UTF8Remote database=============9i with JA16SJISHave tables with japanese column names When our developers try to select a column from remotedb over a dblink they get ORA-00972: identifier is too long In the below example consider each number as a Japanese character. select 123456789012 from tablex@flip;ERROR at line 1:ORA-00972: identifier is too longWe tried from sql*plus and plsql devWhat is that to be done to get the query run?Is this smetin to do with the nls_lang ??
after a while of successless searching I post this thread now:Maybe this problem belongs also to the ASP-Area because I have problems with an SQL-Statement only when I try to use it in an classic asp-page. here some code:<%@ Language=VBScript %> <%Option explicit%> <% Response.Expires = 0 Response.AddHeader "Pragma", "No-Cache" Response.CacheControl = "no-cache" //Dates Dim MonthMinus0, MonthPlus1 MonthMinus0 = DateDiff("s","1970/1/1",DateSerial(Year(now()),Month(now()),1)) MonthPlus1 = DateDiff("s","1970/1/1"
I am writing java code for extracting the xmltype contents . I am using the Oracle10g r2.1. If I use my select query inside the prepare stament , code is working finelike thisconn.prepareStatement("select extractValue(object_value,'/population/growth/yearincrease') \"yearincrease\", extractValue(object_value,'/population/growth/publicworry') \"publicworry\" from population_country where ExistsNode(object_value,'/population/growth[yearincrease >30 and yearincrease < 110]')= 1");The same code ,throws Oracle error ORA-00972: if I put all these values in diffrent string and load the prepare
- I stepped over this problem while testing a new procedure: 7 WHENEVER SQLERROR exit8 SELECT 'STOP! Missing refresh group!' " ' FROM DUAL9 WHERE NOT EXISTS (SELECT refg_name FROM SYS.DBA_REFRESH WHERE rname='Thingy')10 SELECT 1/(sign(count(*)) FROM (SELECT refg_name FROM SYS.DBA_REFRESH WHERE rname ='Thingy')I always get an ORA-00972: identifier is too long when I try to run these lines.But WHERE is there a too long identifier? "STOP! Missing refresh group!" is only 28 characters long.Somebody got a clue?
Howdy expert,select sum( case when FULLOPERATION like 'CREATE%MTNSUB%'and FULLRESULT like 'RESP:0%' then 1else 0 end ) "succesfully created minor user in the oracle database"from TAB_PROCLOGwhere (FULLOPERATION like '%MTNCSUB%')and FULLRESULT like 'RESP:0%'and STARTTIME between TO_TIMESTAMP ('2009-05-16 22:00:00','yyyy-mm-dd hh24:mi:ss')and TO_TIMESTAMP ('2009-05-16 23:59:59','yyyy-mm-dd hh24:mi:ss'); I execute the command through ToadClient. But giving the error "ORA-00972: identifier is too long Cause: An identifier with more than 30 characters was specified. Action: Specify at most 30 chara
I've a litlle issue and I hope soemeone can help.I'm running a recently migrated database on RH5.3 and Oracle Version is 10.2.0.4 Enterprise.Old Version was 9.2.0.6.After Migration, and all necessary check, Invalid Objects, Constraint, Data Integrity and so on everything was fine.just during the import I got the Follwing Error :IMP-00017: following statement failed with ORACLE error 972:"GRANT SELECT ON "V$UPDATE_FORM" TO "R_IWS_READ""IMP-00003: ORACLE error 972 encounteredORA-00972: identifier is too longAnd Now when Doing a Select on that View I get the same error Message.IWS@cfmd > r1 se
while executing this procedure , I am getting follwoing errors:Create or Replace procedure ADD_CUSTOM_INDEX isINDX_NOT_EXIST Number; CREATE_SQL_STATMENT VARCHAR2(1500);ALTER_SQL_STATMENT VARCHAR2(150);CURSOR C1 IS select INDEX_NAME,CREATE_DDL FROM W_CUSTOM_TEST, WC_COMPANY_G WHERE W_CUSTOM_TEST.SYS_TENANT_ID = WC_COMPANY_G.BU_ID;BEGINfor V_ROW in C1 loopSELECT COUNT(USER_INDEXES.INDEX_NAME) INTO INDX_NOT_EXIST FROM USER_INDEXES WHERE USER_INDEXES.INDEX_NAME = V_ROW.index_name;IF INDX_NOT_EXIST = 0 THENCREATE_SQL_STATMENT := ''|| '"'|| V_ROW.CREATE_DDL ||'"' ||'PARALLEL NOLOGGING';EXECUTE IMMED
The following is my code...I got THE FOLLOWING ERROR'ORA-00972: identifier is too longORA-06512: at "VVMS_BATCH.QUEUE_DYNAMIC", line 26ORA-06512: at line 2'Code:create or replaceprocedure sales_dynamic is cursor cur_sales is select sales_CATEGORY_ID,sales_ITEM_STATUS,sales_ITEM_KEY,sales_ID from sales_ITEM_HISTORY where sales_ITEM_STATUS = 'OH' and ONHOLD_DT < sysdate;/*v_err_code number;v_err_msg varchar2(64);*/type v_source_table is table of sales_category.source_table%type;z_v_source_table v_source_table := v_source_table();stmt long(2000);v_ot varchar2(2);begin for i in cur_sales loopbe
said: Has anyone everyone ever come across the error RQP-DEF-0177 - ORA-00972: identifier is too long??This happens on a report when it is run in PDF. The report prompts, validates and runs fine in HTML mode, in PDF it prompts and validates, but throws this error right before it should render??Does anyone know if there is any fix? We are running Cognos 8.2 on this server. We are going to upgrade to 8.3 on monday night, but need the report monday afternoon so not sure if there is a fix for 8.2, or if it is a problem in 8.3 as well.
Shashidhar Manthena said: Hi All, I have a simple report with a UNION query. When I view tabular data, it pops up an error saying:UDA-SQL-0107 A general exception has occurred during the operation "prepare". ORA-00972: identifier is too long RSV-SRV-0042.When I execute the generated sql of the projected UNION query in Toad, it is being run perfectly, but fails when I just view the tabular data of tha query in Report Studio.Did anyone have this kind of experience?Appreciate if you could help me trace the problem.
Andrew Grice said: Hi,Using Cognos 8 Report Studio Version 8.2. I am receiving the following error when trying to run a report to either csv, excel or pdf. " UDA-SQL-0107 A general exception has occurred during the operation "prepare". ORA-00972: identifier is too long RSV-SRV-0042 "Is anyone able to assist.
I'm having an error when running any entity (j2ee EJB entity) method. It´s ORA-00972 Identifier is too long. I now that this may caused by a field's name longer than 30 characters, or data tipe incompatibility. I tried to run an entity over a table with anly an autonumeric PK, entityTable as entity's name and pk the field but the same error again. Later, I created some new workspaces and added old projects to them. Some of them worked and others didn´t. Actually a workspace, which was working perfect, throws again this error.I try my entity beans at other PCs and them worked.This must be an
I have a version enabled table 'BOB_MARKETING_CONSULTANT'and I want to do some DDL operation on it.Every time I execute the following statement:exec dbms_wm.BeginDDL('BOB_MARKETING_CONSULTANT');I get an error:ORA-00972: identifier is too longThe table name is less than 25 characters and the table could be version enabled fine....so what could be the reason???
While trying to publish an application I get a "CONS-10049 / ORA-00972: identifier too long" error message for tables that have names of 26 or 27 characters long. It looks like it includes the owner/schema name to the length calculation and thinks the table name is exceeding 30 characters. If I remove the tables with these long names the app is built without an error. fyi - The table already exists in an O9iR2 database, I am simply trying to import it for this application.Any ideas? TIA,Scott
we get an ORA-00972 identifier too long when creating synonyms with names that have 32 characters. This happens only in XE, other Oracle editions do not have this problem. Is there any other solution than to shorten the names?
Hi, I have setup HS on a oracle database connecting to sysbase. i can do "desc log@sybaselink" with no problem. but when i do " desc log12439842348573857938579345@sybaselink" it returns error says ORA-00972: identifier is too long. that is the table name we cannot change it short. please advise.
I want to insert a blob into my create script with this insert query. But i get the errorError at Command Line:3 Column:1Error report:SQL Error: ORA-00972: identifier is too long00972. 00000 - "identifier is too long"*Cause: An identifier with more than 30 characters was specified.*Action: Specify at most 30 characters.any ideas?insert into image_templates(image_template_id,name,description,min_cm,template_blob,template_name,template_mime,max_images) values ('12','test','test','10',FFD8FFE000104A46494600010101006000600000FFE1001645786966000049492A0008000000000000000000FFDB004300080606070605080
I'm trying to help a client here that needs to put a datafile in auto extend, and when he typed the code he gets this error:ORA-00972: identifier is too long Can someone help please?
is there any way to bypass the "ERROR at line 1: ORA-00972: identifier is too long" in Oracle 11g, i.e. to exceed the 30-characters limit of column header?
I'm trying to create standby control file but I got an error:SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS "/oracle/PRO/oraarch/standbyPRO.ctl";ALTER DATABASE CREATE STANDBY CONTROLFILE AS "/oracle/PRO/oraarch/standbyPRO.ctl"*ERROR at line 1:ORA-00972: identifier is too long How can I fix this?
I have an issue on Application Express Form. On my form I have fields that one must fill in to save info on the database. This works fine until I click create button - I get the following error:ORA-06550: line 1, column 243: PL/SQL: ORA-00972: identifier is too long ORA-06550: line 1, column 7: PL/SQL: SQL Statement ignored Unable to process row of table FIS_REPAT_WITH_APPLICANT_INFO. I have checked the table name length & it's 28 characters long. What could be the problem with this? Any help is appreciated. Thank you in advance.
doing a simple update to a column I added to a table. Maybe it's not enough coffee but I do this all the time. This time I'm getting this error.ORA-00972: identifier is too long I've checked my sequence length, my triggers, the table name is DOC_CONTROL...and I can't find where anything is over 30 characters. Tablespace hasn't changed since I did this before. UPDATE DOC_CATALOGSET ECR_LINK_PATH = "file://Apex/DocConDB500/Files/docControl/ECR%20Folder/"WHERE DOC_CAT_ID > 0
I have been having some difficulties with dropApplicationTableIndex. It raised an ORA-00972 exception : java.sql.SQLException: ORA-00972: identifier is too longat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)at oracle.jdbc.driver.OracleStatement.doE
SQL>SQL> BEGIN2 DBMS_SCHEDULER.CREATE_JOB(3 job_name=>'HR.GATHERSTATS_REGIONS',4 job_type => 'PLSQL_BLOCK',5 job_action => "DBMS_STATS.GATHER_TABLE_STATS (ownname =>'HR',tabname =>'REGIONS',estimate_percent => 2, \6 method_opt => 'FOR ALL INDEXED COLUMNS SIZE AUTO',cascade => TRUE,degree => 8);",7 start_date=>TRUNC(SYSDATE)+23/24,8 repeat_interval=>'TRUNC(SYSDATE+1)+23/24',9 /* next night at 11:00 PM */10 comments => 'Explicit Stats Gathering');11 END;12 /ERROR:ORA-00972: identifier is too long - When I try to create a job via dbms_scheduler it gives m
I am receiving an " ORA-00972 - Identifier Is too Long" error message when I try to update a BLOB field with file contents from a gif file._GIF FILES:_c:\bl\x_PageLayout-4_LA.gif (15K)c:\bl\x_PageLayout-4_Spec.gif (21k)===================================================================================================================================ORACLE DATABASE (STYLEELEMENTPIX TABLE):STYLE_ID NUMBER SEQ_KEY NUMBER PIX_NAME VARCHAR2(30 BYTE) PIX BLOB PIX_LABEL VARCHAR2(30 BYTE) MODIFY_DATE DATE PIX_TYPE CHAR(1 BYTE) DEFAULTDISPLAY CHAR(1 BYTE) PIX field currently is null=====================
Would someone please look at this code? For all the changes I made it still returns the same error above. If I can not use the TYPE TABLE ... would be great. The select statement is going return several values with the same date (sysdate-1). I am only interested in getting a distinct value of this but I used that word and it screamed. So as far as I can see I have to capture all of them then do a select distinct on the table type to get my answer. Any suggestions in re writing the code as necessary is appreciated.This is another block of the continuing drama.DECLARElatest_day varchar(12); TYPE
i got "ORA-03113: end-of-file sul canale di comunicazione" when i execute the following query:Select distinct A_FIELD_NAME From A_USER.A_TABLE;I create a new table (aaa) with a field (aaa varchar2(5)), a then i insert some record in this new table. Then i try the following query:select count(distinct aaa) from aaa;and this one doesn't got error.Why? I need a select count distict, how can i do?Sandro
Query 1: SELECT distinct to_date(to_char(EARLY_PICKUP_DATE)) as EARLY_PICKUP_DATEfrom order_Releasewhere EARLY_PICKUP_DATE > sysdate -2Works fine.xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxHowever, when I execute the same quey, but using an internal subquery it fails...Query2: select distinct sql1.EARLY_PICKUP_DATEfrom(sELECT to_date(to_char(EARLY_PICKUP_DATE)) as EARLY_PICKUP_DATEfrom order_Release) sql1where sql1.EARLY_PICKUP_DATE > sysdate -2;(sELECT to_date(to_char(EARLY_PICKUP_DATE)) as EARLY_PICKUP_DATE*ERROR at line 3:ORA-01847: day of month
All, I want to be able to use a alias that is more then 30 characters longex:select column_name1, column_name2 AS "I have a very long column name here"from employee;I know that you cannot store a column name, table etc.. with more than 30 characters, but I would like to be able run a select statement so I can export the information to my client with a more meaningful column name.Any help would be great
I have this problem, I'm not sure what happenned. It only happepned when i Code in asp classic. It work fine in SQLDeveloper and ColdFusion same query and same data output.The Query : -in asp :strSQL = "select option_id, option_description,insurance_cost_rec_percent,gove rnment_cost_rec_percent,DOCUMENT_REC_INFO," & _" option_short_name, probability_of_occurance,decile_selected_ind, option_selection_rationale,currency_id," & _" option_number_selected,option_budget_aggregate_tot al,probability_of_occurance," & _"NVL((SELECT no_of_years-DECODE(TO_CH
I am working on webGUI for networking application.There are around 30 to 35 network related parameters user would enter by PHP forms. I already have PHP page and I can print all this parameters entered by user in PHP script. I have another process running on same system (Linux) and uses socket to receive data from PHP script. Here is the sample code// PHP code$sock = socket_create(AF_INET, SOCK_STREAM, SOL_TCP)socket_bind($sock, "127.0.0.1", 1000);$msg_code =0xc010;$msg_len = 0x10;$msg_data = 0xa0b012cc;$msg = $msg_code $msg .= $msg_len $msg .= $msg_data socket_write($msgsock, $msg,
Facts:oracle standard edition 10.2.0.1 OS: RHEL V5 64 bits.I have a problem with this plsql code:******************************************************************************DECLAREe_parent_not_found EXCEPTION;PRAGMA EXCEPTION_INIT(e_parent_not_found,-2291);v_code NUMBER;v_errm VARCHAR2(300);cuentareg NUMBER:=0;CURSOR C1 ISSELECT "num_paq", "formulario",-- tbl 3 cambio de tdato ojoDECODE("cod_docide_dec",6,'09',1,'01',4,'06',7,'08',11,'04',NULL,'15','-','15',"cod_docide_dec") AS ccod_docide_dec,"num_docide_dec","norden","num_correl_a","periodo",-- tbl 3 cambio de tdato ojo"num_docide_aseg",DE
I have a sql query which I'm trying to put into a store procedure. The problem is I cant get the stored procedure to compile. The sql works fine in SQL window. Even when I run the full query below, it works no problem from SQL Plus.CREATE OR REPLACE TYPE BCMD_TMP AS TABLE OF VARCHAR2 (4000)open p_cursor for select column_valuefrom bcmd_companytemp, TABLE(BCMD_TMP (compno, compname));I'm not quite sure what the error means but I'm guessing it is the TABLE part.Here is the full SQL.select column_valuefrom bcmd_companytemp, TABLE ( BCMD_TMP (compno, compname, address,citygroupid,prov,postal,phone
I am trying to use OLEDB , and run a query . Its a simple query . SELECT FIRST_NAME, (SELECT DIVISION_NUMBER FROM DIVISIONS WHERE DIVISION_ID = P.DIVISION_ID) AS DIVS FROM PERSONNEL PI know you can argue that i can join both the tables. But its just an sample structure of the other queries. The point is when there is a query inside the main query , it throws the error. Any solutions ?
I did write a code using execute immediate command. This command mainly creates a cursor that selects table names from user_tab_columns. These table names are then used inside the execute immediate statement in order to apply the same select statement on the table names being selected inside the cursor. The problem is that the above error is thrown saying identifier is too long . I can't figure out how to solve this issue.Please find the code developed below:Declarecursor C_1 is select distinct table_namefrom user_tab_columnswhere column_name = 'PROGRAM_UPDATE_DATE' AND table_name LIKE 'MISPA%
HiCan you please let me know if I can get over that problem of the table or column name restriction of 30 character?I know this is a basic limitation but i need to enlarge it..thanx
I have the following query which works fine when used with Sqlplus, but fails when called from within crytal reports (using an OleDB connection). I saw an open Oracle bug number 3025605 on some website, but haven't been able to look up any additional information on the error. The query fails with Ora-00972.SELECT "CLIENTS"."CLTFIRSTNAME","CLIENTS"."CLTLASTNAME", "CLIENTS"."CLTMIDDLENAME", "SCHEDULE"."SCSESSIONDATE", (SELECT r.REMPFIRSTNAME||' '||r.REMPLASTNAMEFROM REFAGENCYEMPLOYEES R WHERE "R"."REMPLOYEEID" = "SCHEDULE"."SCREFPERSON1ID") REFAGENT1,(SELECT r.REMPFIRSTNAME||' '||r.REMPLASTNAMEF
Following Select generates ORA-22813Select fid, geom from tab1 order by fidThere's index on fidWithout order by claus this works fineORA Doc says ORA-22813 operand value exceeds system limitsCause: Object or Collection value was too large. The size of the value might have exceeded 30k in a SORT context, or the size might be too big for available memory.Action: Choose another value and retry the operation.We need the objects with this order by - what can we do ?
Select with Multiple Summing Returns ORA-07445select d.tax_name,d.tax_type, sum(a.total_amount) as invoice_value, sum(a.line_amount) as Mat_value, sum((select sum(c.tax_amount) from ja.ja_in_ra_cust_trx_tax_lines c, ja.ja_in_tax_codes d where c.link_to_cust_trx_line_id=a.customer_trx_line_id and c.tax_id=d.tax_id and d.tax_name like 'SALE%' and d.tax_name like 'SALE.BED%')) as BED, sum((select sum(c.tax_amount) from ja.ja_in_ra_cust_trx_tax_lines c, ja.ja_in_tax_codes d where c.link_to_cust_trx_line_id=a.customer_trx_line_id and c.tax_id=d.tax_id and d.tax_name like 'SALE%' and d.tax_name like
Following query of mine fails with ORA-01555:select xx from a where a.xx NOT IN (select xx from b where status=0)Tables a & b have million rows approx. How can I tune the query (to remove "NOT IN").The explain plan is:0 SELECT STATEMENT Optimizer=CHOOSE (Cost=705828732 Card=55061 Bytes=3468843)1 0 FILTER2 1 TABLE ACCESS (FULL) OF 'A' (Cost=1773 Card=55061 Bytes=3468843)3 1 PARTITION RANGE (ITERATOR)4 3 PARTITION LIST (ALL)5 4 TABLE ACCESS (FULL) OF 'B' (Cost=12819 Card=45553 Bytes=2596521)
the query below fill my 32GB temporary tablespace and I get an ORA-01652.SELECT DISTINCT x.nuaud, TO_CHAR (x.times, 'DD/MM/YY HH24:MI'), x.inde1, x.inde2, x.inde3, x.inde4, NVL (y.litab, '????'), NVL (x.useru, SUBSTR (SUBSTR (x.progr, 1, INSTR (x.progr, '.') - 1), 1, 8 ) ), x.dmlst, x.nublk, x.blkfc, x.nbord, 'A' FROM audtab x, audlib y WHERE x.cotab = y.cotab(+) AND DECODE (y.colan(+), 'A', 1, 0) = 1 and exists (select 1 from audtri z where z.cotab = x.cotab) ORDER BY 1, 12, 10; some informations here:SQL> select 'audtab', count(1) from audtab 2 union all 3 select 'audlib', count(1) from a
I am using Pro*C (Oracle 10g on Itanium platform) to invoke PL/SQL procedure to read RAW data from database, but always encoutered ORA-01458 error message.Here is the snippet of Pro*C code:typedef struct dataSegment{unsigned short len;unsigned char data[SIZE_DATA_SEG];} msg_data_seg;EXEC SQL TYPE msg_data_seg IS VARRAW(SIZE_DATA_SEG);EXEC SQL BEGIN DECLARE SECTION;unsigned short qID;int rMode;unsigned long rawMsgID;unsigned long msgID;unsigned short msgType;unsigned short msgPriority;char recvTime[SIZE_TIME_STRING];char schedTime[SIZE_TIME_STRING];msg_data_seg dataSeg;msg_data_seg dataSeg1;msg
When I implemented the Ruby on Rails article posted in http://www.oracle.com/technology/pub/articles/haefel-oracle-ruby.html, I found the following problem:Everything was fine until I decided to test my application. When my web app tried to access some record of the table, the following error happened:OCIError: ORA-01722: invalid number: select * from (select raw_sql_.*, rownum raw_rnum_ from (SELECT * FROM comics WHERE (comics.id = '2.0') ) raw_sql_ where rownum <= 1) where raw_rnum_ > 0 F:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_ad
Kindly help how to fix the following query because I'm getting Oracle error:ORA-01446.select * from edy_raw_data a where rowid in ( select max(rowid) from( select email,max(date_updated) from edy_raw_data bwhere b.email=a.emailgroup by email ))The query select the max rowid from a sub query with group by.
I'm trying to replace text values in a long raw field that contains text data. Normally this is handled through the application, but I'm having to clean up the audit data. I tried the following to just view the data thru sqlplus but I'm getting an error ORA-00997select utl_raw.cast_to_varchar2(dbms_lob.substr(blobvalue,1,32000)) from controldata where controlvalueid = 111111I basically need to update the field such asupdate controldata set blobvalue=replace(blobvalue,'OLDVALUE','NEWVALUE') where controlvalueid=111111;How do I do that with a long value?
I am new to VC++. I know C and C++ so I know the programming concepts. Now i am developing an application for opening a .hex file and load it to microcontroller. Also I want to get .hex file from microcontroller.Microcontroller programming has been taken care of. Now I want to write a program to open a .hex file and when the OPEN button is pressed it should save file content (not more than 256 bytes) in a buffer.Also when application reads bytes from microcontroller it should be saved in a .hex file.Till now I could develop to a point where it is opening a dialog box and select a hex file but
I bet this one will stump the GURUs. Good luck with this puzzle.I need to do an outer join using a column where if the key is found, I need to select the max of that column. Oracle won't let me do an outer join to a subquery. Does anyone have an ideas, just using straight SQL? I can't use stored procedures or Code.Table1ID_Number, NameTable2ID_Number, Date_From, Date_To, AddressThis is the Query I need (But it's giving me a ORA-01799):Select Table1.ID_Number, Table1.Name, Table2.AddressFrom Table1, Table2Where Table1.ID_Number = Table2.ID_Number(+)Table2.Date_From(+) = (Select max(b.Date_From)
When I run following query without MAX() function (used to get latest date)the query runs fine, but if I use the MAX() function I get 'ORA-03113: "end of file on comunication channel". I am using TOAD V6.0 to run query. Pleasehelp me understand the problem. Here are two tables and queries in question.Table: DIST_SColumn: DISTID, Char(4)Values: AAAABBBBCCCCTable: DIST_SDColumn: DISTID, Char(4),STATE, Char(2)Row_Update_DT, DateValues: AAAA, NJ, 1/1/2004AAAA, NY, 2/1/2004BBBB, NC, 1/1/2004Query that works: SELECT *FROM DIST_S FULL JOIN(SELECT DIST_SD.DistID AS DistID, DIST_SD.STATE AS S
How can I restructure this query to avoid the dreaded ORA-00979?SELECT (TRUNC(address / 16777216)) AS "BLOCK_NUMBER", (COUNT(*)) AS "UTILIZED"FROM "NET_IPV4ADDRESS"WHERE ("NET_IPV4ADDRESS"."ADDRESS" >= 0 AND"NET_IPV4ADDRESS"."ADDRESS_DOMAIN_ID" = 1 AND "NET_IPV4ADDRESS"."ADDRESS" <= 4294967295 AND "NET_IPV4ADDRESS"."PING_ALIVE" = True )GROUP BY TRUNC(address / 16777216)ORDER BY "NET_IPV4ADDRESS"."ADDRESS" ASC;
I created some tables for a database that is going to be OS independent.When i put some values to a specific table, I have tha following problem:At the time that i put the values, to the table, i receive the error message "ORA-00928, SELECT Keyword missing"This table has a foreign key which is referenced to another table and column.i don't think that i am making any mistake in the setting of the constraintsm because i made 2 more tables with the same constraints and i didnot have any problem.I am confused, cause I am now bacoming familiar with the oracle environment and i don't know many thing