嵌套表和数组
declare
one_thing varchar2(10) := 'Three';
function ord(n number)
return varchar2
is
type ord_type is table of varchar2(10);
aa ord_type := ord_type('One','Two','Three','Four','Five');
begin
return aa(n);
end;
begin
if one_thing = ord(5) then
dbms_output.put_line(one_thing||ord(5));
else
dbms_output.put_line(ord(5));
end if;
end;
oracle保存图片
先在本机建目录，把照片放在目录下，oracle会根据过程读取二进制再存储
create table t_photo (pno char(3),picture blob);
select * from t_photo;
create directory "dir3" as 'D:\appdata\image1'; -- 路径，dir3是虚拟路径
create or replace procedure pro_insert(in_pno in t_photo.pno%type,
filename varchar2) as
f_lob bfile;
b_lob blob;
len1 number;
begin
declare
one_thing varchar2(10) := 'Three';
function ord(n number)
return varchar2
is
type ord_type is table of varchar2(10);
aa ord_type := ord_type('One','Two','Three','Four','Five');
begin
return aa(n);
end;
begin
if one_thing = ord(5) then
dbms_output.put_line(one_thing||ord(5));
else
dbms_output.put_line(ord(5));
end if;
end;
oracle保存图片
先在本机建目录，把照片放在目录下，oracle会根据过程读取二进制再存储
create table t_photo (pno char(3),picture blob);
select * from t_photo;
create directory "dir3" as 'D:\appdata\image1'; -- 路径，dir3是虚拟路径
create or replace procedure pro_insert(in_pno in t_photo.pno%type,
filename varchar2) as
f_lob bfile;
b_lob blob;
len1 number;
begin
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12961536/viewspace-769532/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
