레퍼런스를 보믄..다음과 같이 나오는구먼유~
LONG columns cannot appear in certain parts of SQL statements:
1. WHERE clauses, GROUP BY clauses, ORDER BY clauses, or CONNECT BY clauses or with the DISTINCT operator in SELECT statements
2. The UNIQUE operator of a SELECT statement
3. The column list of a CREATE CLUSTER statement
4. The CLUSTER clause of a CREATE MATERIALIZED VIEW statement
5. SQL functions (such as SUBSTR or INSTR)
6. Expressions or conditions
7. SELECT lists of queries containing GROUP BY clauses
8. SELECT lists of subqueries or queries combined by set operators
9. SELECT lists of CREATE TABLE ... AS SELECT statements
10. SELECT lists in subqueries in INSERT statements
말씀하신 것은 9번에 해당하는군요~
그려서..에러가 나는 것 같은디용~
>>mis74 님께서 쓰시길<<
:: 제가 질문한건요.... long을 서브쿼리로 질의 하는것이 아니라
:: SQL> create table ccc (
:: :: 2 aaa varchar2(100),
:: :: 3 bbb long);
::
:: 이 경우에
:: 서브쿼리를 이용하여 또 하나의 테이블 생성시를 이야기 하는 것입니다.
:: SQL> CREATE TABLE ddd
:: STORAGE ( ... )
:: AS SELECT bbb FROM ccc;
:: 하면 에러가 뜨거든요.... 흑흑
:: ORA-00997: illegal use of LONG datatype
::
::
::
::
::
::
::
:: >>정명환 님께서 쓰시길<<
::
:: :: 간단히 해봤는데요~
:: ::
:: :: SQL> create table ccc (
:: :: 2 aaa varchar2(100),
:: :: 3 bbb long);
:: ::
:: :: Table created.
:: ::
:: :: // 인라인뷰~
:: :: SQL> select * from (select bbb from ccc);
:: :: no rows selected
:: ::
:: :: // 서브쿼리~
:: :: SQL> select *
:: :: 2 from aaa
:: :: 3 where exists
:: :: 4 (select 'x' from aaa where ccc is null);
:: :: no rows selected
:: ::
:: :: 문법에는 에러가 없는 것 같은데요??
:: ::
:: :: >>mis74 님께서 쓰시길<<
:: ::
:: :: :: 서브쿼리를 사용하여 테이블을 생성시에 long type을 포함 할 수 있는지
:: :: :: 궁금해서 글을 올립니다.
:: :: ::
:: :: ::
:: :: :: ORA-00997: illegal use of LONG datatype
:: :: :: 에러메세지가 뜨는데 원래 서브쿼리로 테이블 생성시에는
:: :: :: long 컬럼은 포함할 수 없는지....
:: :: :: 고수님덜아 갈켜줘요
:: :: ::
:: :: ::
|