Modify the oracle varchar2 type field length report "ORA-00904: invalid identifier" error

2010-12-20  来源:本站原创  分类:Database  人气:153 

Today, I want to modify the oracle varchar2 type in the field length report "ORA-00904: invalid identifier" error, Modify the oracle varchar2 type field length report "ORA-00904: invalid identifier" error

The original sql is

alter table AC_ARCHIVESSCOPE modify SCOPE VARCHAR2 (1000);

Later, the above statement into the following amendments success

alter table AC_ARCHIVESSCOPE modify (SCOPE VARCHAR2 (1000));

相关文章
  • Modify the oracle varchar2 type field length report "ORA-00904: invalid identifier" error 2010-12-20

    Today, I want to modify the oracle varchar2 type in the field length report "ORA-00904: invalid identifier" error, The original sql is alter table AC_ARCHIVESSCOPE modify SCOPE VARCHAR2 (1000); Later, the above statement into the following amend

  • Modify the oracle varchar2 type field length in the report "ORA-00904: invalid identifier" error 2010-12-20

    Today would like to modify the oracle varchar2 type field length in the report "ORA-00904: invalid identifier" error, Sql is the original alter table AC_ARCHIVESSCOPE modify SCOPE VARCHAR2 (1000); The above statement was later changed to the fol

  • ORACLE date type field in the treatment of 2010-08-24

    ORACLE date type field in the treatment of ORACLE / JSP technology involves the date, time of treatment (1) in the English version of ORACLE in default date format 'DD-MON-YY', such as '01-JAN-98 ' Speaking of the Chinese version of the ORACLE defaul

  • Oracle date type field processing of Features 2011-04-22

    Mainly to tell you today is the Oracle date type field of the practical relevance of the application process, as well as Oracle / JSP technology involved in the date, time and some problems of handling, if you are Oracle date type field, then deal wi

  • Spring operations in clob oracle application type field 2010-04-06

    Today should be a oracle clob type field operations in more things, to the Internet to find a moment, the example of many. Summarized here under: 1, insert the clob field private LobHandler lobHandler = new DefaultLobHandler ();; CommonsDbcpNativeJdb

  • ORACLE date type field in the processing 2011-08-24

    (1) in the English version of ORACLE, the default date format 'DD-MON-YY', for example, '01-JAN-98 ' Speaking of the Chinese version of the ORACLE default date format is 'Day - Month - Year', for example, '21-8-2003 'or '21-August -03' (2) convert st

  • oracle date type field of operation (transfer) 2011-03-30

    The operation of the oracle in java, the date field is a headache, in fact, a closer look it is not difficult to obtain. Example to illustrate: Table book has name varchar2 (20) / / book titles, buydate Date / / date of purchase two fields. Has creat

  • ORACLE ORA-00904 invalid identifier error 2010-12-09

    The original SQL statement is added reason for double quotes, the value to single quotes on the line! It seems the SQL in single quotes and double quotes have a good refresher on the difference! Another possible reason is that the database table colu

  • Oracle / SQL to modify the field type and length 2011-06-27

    Oracle / SQL to modify the field type and length Standard SQL statements to modify the field type and length: ALTER TABLE tableName modify column columnName type; For example, changes to field types Mysql statement: alter table test modify column nam

  • ORACLE in a VARCHAR2 field length is defined by byte - a problem easily overlooked 2011-03-23

    Many beginners do to build the database, it will ignore such a problem: ORACLE in a VARCHAR2 field length is defined by byte. If the database character set is used GBK, GB2312, or other fixed-length character sets, the problem seems to be ignored, be

  • db2 operations (take the former 10. modify the field length. increase the field) 2010-03-03

    db2 db2 fetch the first 10 records of changes to increase field length field method db2 db2 fetch the first 10 records db2 => select istop from news where id = 370 fetch first 10 rows only db2 modify the field length db2 alter table db2admin.config a

  • InnoDB tables to quickly modify a varchar field length of the program 2011-01-05

    The previous article mentioned at the end of the field quickly modify the length of InnoDB. In fact, the scene is used in the design table, reserved varchar type field if necessary, can not determine the actual required length. And when the fields ne

  • mysql command-line commands and SQL statements, MySQL modify delete increase the field type, field data, etc. 2011-06-15

    I. Common mysql command-line command 1 Start service net start mysql MYSQL Stop service net stop mysql MYSQL 2. Netstat-na | findstr 3306 view was listening port, findstr to find the back of the port for the existence of 3. MYSQL landing on the comma

  • VARCHAR2 CLOB field type conversion 2011-08-22

    VARCHAR2 CLOB field type conversion Colleagues came to me today, she created a table, accidentally into CLOB type of field, Order, when not supported, so would like to turn back, but also save the data inside. Provides a step to her: 1. The establish

  • [Transfer] mysql command-line commands and SQL statements, MySQL modify delete add field type, field data, etc. .. 2011-08-23

    I. Common mysql command-line command 1 Start service net start mysql MYSQL Stop service net stop mysql MYSQL 2. Netstat-na | findstr 3306 view was listening port, findstr to find the back of the port for the existence of 3. MYSQL landing on the comma

  • Chapter 2 of Oracle query Oracle Data type functions 2011-05-01

    Chapter 1 Introduction to Oracle Oracle Chapter 3, Oracle locks, table partitioning Chapter 2 of Oracle query Oracle data types, functions Note: This chapter provides Oracle SQL help file (PDF) Download 1, the technical objectives Understanding of Or

  • oracle string type Xiangjie 2010-07-03

    Sort out the char, character, varchar, varchar2, nchar, nvarchar2, long, long raw, and LOB types of comparison between First, the concept type char: Fixed-length string type, when the stored data is not reached the set maximum, it will append a space

  • Oracle RAW type of analysis 2010-09-03

    On the detailed anatomy of Oracle Raw type the following article mainly for Oracle Raw type of detailed explanation, we first of all I start from the concept of RAW, and its no matter which side is similar to the CHAR, their statements for the RAW (L

  • oracle date type of solution in 2011-05-03

    Conversion 1 Use getTime () function of these two classes provide getTime () function that returns the corresponding number of milliseconds (long type). Conversion can be achieved using this function: java.util.Date utilDate = new java.util.Date (sql

  • Tomcat and Weblogic environment, the handling of the BLOB type field 2010-07-13

    Development projects generally do like to use Tomcat test environment, the development is completed need to move weblogic, this time to continue to find problems. As weblogic rigor, process some data conversion error, some small The problem is well r