ID NOT NULL NUMBER(2) CNAME VARCHAR2(40) ENAME VARCHAR2(30) FORM VARCHAR2(15) CITY VARCHAR2(20) CONF VARCHAR2(1) CHAMS VARCHAR2(200) COACH VARCHAR2(15) REGULAR VARCHAR2(60) PLAYOFF VARCHAR2(50) HOME VARCHAR2(40) STARTS VARCHAR2(15) EXP VARCHAR2(15) CHE VARCHAR2(15) ADDR VARCHAR2(40) HISTORY NVARCHAR2(2000) LINKS VARCHAR2(100) LOGO BLOB PIC BLOB----------------------------------------------------------------------- 这里面有关键字吗?
即使是关键字也可以的,只是不推荐使用而已。 一个表的大字段不能在select list里面: select pic from table ...是不行的。
You cannot specify a LOB column in a SELECT ... DISTINCT or SELECT ... UNIQUE statement or in a join. However, you can specify a LOB attribute of an object type column in a SELECT ... DISTINCT statement or in a query that uses the UNION or MINUS set operator if the column’s object type has a MAP or ORDER function defined on it.
我在ORACLE817下测试过,如果有blob类型的字段,用SELECT * FROM ...的确会出来这样的提示。都怪我学艺不精,误导你了
CNAME VARCHAR2(40)
ENAME VARCHAR2(30)
FORM VARCHAR2(15)
CITY VARCHAR2(20)
CONF VARCHAR2(1)
CHAMS VARCHAR2(200)
COACH VARCHAR2(15)
REGULAR VARCHAR2(60)
PLAYOFF VARCHAR2(50)
HOME VARCHAR2(40)
STARTS VARCHAR2(15)
EXP VARCHAR2(15)
CHE VARCHAR2(15)
ADDR VARCHAR2(40)
HISTORY NVARCHAR2(2000)
LINKS VARCHAR2(100)
LOGO BLOB
PIC BLOB-----------------------------------------------------------------------
这里面有关键字吗?
一个表的大字段不能在select list里面:
select pic from table ...是不行的。
UNIQUE statement or in a join. However, you can specify a LOB attribute of an
object type column in a SELECT ... DISTINCT statement or in a query that uses
the UNION or MINUS set operator if the column’s object type has a MAP or
ORDER function defined on it.