Re: Best way to update large field

The syntax is
update <table>
set <column>= ( <subquery>)

NOT
set <column > = "<subquery>"

Regards,

Sybrand Bakker, Oracle DBA

"James Williams" <techsup_at_mindspring.com> wrote in message news:3b0bf935.110601234_at_news.mindspring.com...
> Get the dread ora_00972 trying to do the below. I can insert the row
> but would like to update an existing row. Any good id
>
> SQL> @order
> ERROR:
> ORA-00972: identifier is too long
>
>
> SQL> edit order
> No lines in the buffer
> "order.sql" 3 lines, 331 characters
> 1 UPDATE control
> 2 SET ENTITY_LIST_SQL = "select (entity_key) from it_order where
> to_date(
> due_dte, 'YYYYMMDD' ) < (sysdate - entity_criteria) and cmpl_stat_cd
> NOT LIKE '
> %' and cmpl_stat_cd IS NOT NULL and it_order.cis_ordr_nbr in (select
> cis_ordr_n
> br from upl_detail_at_purge38) order by (entity_key)"
> 3 WHERE ENTITY = 'ORDER'
> ~
>
> SQL> show user
> USER is "XXX"
> SQL> desc control;
> Name Null? Type
> ----------------------------------------- --------
> ----------------------------
> ENTITY NOT NULL VARCHAR2(30)
> PROCESS_TYPE NOT NULL VARCHAR2(1)
> ENTITY_CRITERIA NOT NULL VARCHAR2(30)
> COMMIT_COUNTER NOT NULL NUMBER(8)
> LUD_START DATE
> LUD_STOP DATE
> REVISION_CD NOT NULL VARCHAR2(1)
> LUD NOT NULL DATE
> HISTORY_FLAG VARCHAR2(1)
> ENTITY_LIST_SQL VARCHAR2(500)
> DESCRIPTION VARCHAR2(5
Received on Wed May 23 2001 - 13:10:32 CDT