Long Datatypes

[badrinathn]

Hi,

I have to create a table based on another table containing a 'Long' datatype.

I can't even insert a long column from one table into another table with long datatype.


How do I go ahead to insert 'long' column of one table into another table

Badrinath

[deggzy]

Hi,

If your longs contain less than 4001 characters then you could write a little bit of plsql to extract from table1 and populate table2.

HTH

[badrinathn]

The field is specified as Long. No length is specified. I think It can take beyond 4000bytes also.


A) What to do, if it is > 4000bytes.

B)
For the long < 4000, can i write a pl/sql block to
1) read from one table into a cursor
2) open cursor
3) from cursor insert into another table.
Badrinath.

[GreatDBA]

There is Copy Command That can help you Create Table from Other table that have Long Data Type... On Long Datatype, you can not use any Operator and No Function.

Beeter to See Copy Command that's SQL Plus Command.

COPY FROM PMM/PMM@PMMQA CREATE NEWTABLE USING SELECT LOCATION_ID, FULL_NAME FROM LOCATION
............................
COPY FROM SCOTT/TIGER@BOSTONDB -
> CREATE EMPCOPY -
> USING SELECT * FROM EMP
----------------------------
COPY FROM SCOTT/TIGER@BOSTONDB -
> REPLACE EMPCOPY2 -
> USING SELECT ENAME, SAL -
> FROM EMPCOPY -
> WHERE DEPTNO = 30
---------------------
COPY FROM PMM/PMM@PMMQA CREATE NEWLOC USING SELECT * FROM TEMPLOOK

Hope will help You ... This is Only from Oracle 8i 8.1.5 or Higher

[badrinathn]

GreatDBA, that was really great, It worked and solved my problem Thanks.
Badrinath