CREATE TABLE T_Integration_GetServicePersonHaving
(
ID INTEGER NOT NULL,
Person_ID RAW(16) NULL,
ServiceType_ID INTEGER NULL,
Service_ID INTEGER NULL,
Service_Name varchar2(256) NULL,
Photo varchar2(1024) NULL,
Sort_ID INTEGER NULL,
System_ID INTEGER NULL
) 有什么错误吗
(
ID INTEGER NOT NULL,
Person_ID RAW(16) NULL,
ServiceType_ID INTEGER NULL,
Service_ID INTEGER NULL,
Service_Name varchar2(256) NULL,
Photo varchar2(1024) NULL,
Sort_ID INTEGER NULL,
System_ID INTEGER NULL
) 有什么错误吗
解决方案 »
- oracle存储过程的问题。。。急急急.....
- 同库schema同步 如何实现?
- 从Oracle 8i 中将数据导入 9i中,会出什么问题
- 行列转换
- 对于医学信息管理专业,怎样提高自己竞争水平
- 急:我把C:\oracle\oradata\TEST\下面的UNDOTBS01.DBF这个文件删除了,ORACLE不好用了.
- 怎么只SELECT一条记录出来?
- (急)oracle中如何实现级连删除??(在线等待)
- 用ADO怎么执行PL/SQL语句?兄弟就进来,给一点意见有分?
- sql*plus中怎样把存储过程中打印的结果显示出来?
- 请教高手:如果条件A能得到数据则返回,否则返回条件B
- 请高手指教一下!谢谢
(
ID INTEGER NOT NULL,
Person_ID RAW(16) NULL,
ServiceType_ID INTEGER NULL,
Service_ID INTEGER NULL,
Service_Name varchar2(256) NULL,
Photo varchar2(1024) NULL,
Sort_ID INTEGER NULL,
System_ID INTEGER NULL
) 就可以了!
1.Names must be from 1 to 30 bytes long with these exceptions:◦Names of databases are limited to 8 bytes.◦Names of database links can be as long as 128 bytes.If an identifier includes multiple parts separated by periods, then each attribute can be up to 30 bytes long. Each period separator, as well as any surrounding double quotation s, counts as one byte. For example, suppose you identify a column like this:"schema"."table"."column"
The schema name can be 30 bytes, the table name can by 30 bytes, and the column name can be 30 bytes. Each of the quotation s and periods is a single-byte character, so the total length of the identifier in this example can be up to 98 bytes.