| SQL [message #371116] |
Wed, 30 August 2000 19:12  |
Raphael Sebastian
Messages: 2
Registered: August 2000
|
Junior Member |
|
|
How to insert values from a LONG column from one table into a VARCHAR2 in another table. Remember SET LONG and then SUBSTR on the column does not work.
Thanks.
Raphael
|
|
|
|
| Re: SQL [message #371129 is a reply to message #371116] |
Fri, 01 September 2000 22:42  |
Robert Moy
Messages: 1
Registered: September 2000
|
Junior Member |
|
|
You would have to use PL/SQL package procedure
SQL> desc conv
Name Null? Type
--------------------------------------
NAME VARCHAR2(20)
CHARSALARY VARCHAR2(20)
JOB VARCHAR2(20)
SQL> desc wage
Name Null? Type
----------------------------------------
NAME VARCHAR2(20)
SALARY NUMBER(20)
CITY VARCHAR2(20)
MYCOUNT NUMBER
JOB LONG
create or replace package majorchange as
procedure bigchange
(name_name out wage.name%type,
wage_get out wage.salary%type,
name_job out wage.job%type);
end majorchange;
create or replace package body majorchange as
procedure bigchange
(name_name out wage.name%type,
wage_get out wage.salary%type,
name_job out wage.job%type) as
cursor Look_ch is
select name, to_char(salary), job
from wage;
begin
open look_ch;
loop
fetch look_ch into name_name, wage_get, name_job;
exit when look_ch%notfound;
insert into conv(name,charsalary,job)
values(name_name, wage_get,name_job);
end loop;
end bigchange;
end majorchange;
Package body created.
declare
insert_name conv.name%type;
insert_salary conv.charsalary%type;
insert_job conv.job%type;
begin
majorchange.bigchange(insert_name,insert_salary,insert_job);
end;
Good Luck
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
