TYPE tag_myrecord IS RECORD ( col1 Article.column1%type, col2 Article.column2%type, col3 Article.column3%type, col4 Article.column4%type);declare my_record tag_myrecord; begin select * into my_record from Article@DrugMana where article_code=100; end; 你可以试试看,如果不行,就再建个视图看看 create or replace view Article_DrugMana_v as select * from Article@DrugMana;
minkoming:你说的是真的么?那我怎么样才能从一个库导入另一个库中呢?
col1 Article.column1%type,
col2 Article.column2%type,
col3 Article.column3%type,
col4 Article.column4%type);declare
my_record tag_myrecord;
begin
select * into my_record from Article@DrugMana where article_code=100;
end;
你可以试试看,如果不行,就再建个视图看看
create or replace view Article_DrugMana_v as select * from Article@DrugMana;
code [email protected]_code%type,
title [email protected]_title%type,
keyword [email protected]%type,
content [email protected]_content%type,
types [email protected]_type%type,
inputtime [email protected]%type);
提示:
The following error has occurred:ORA-04054: 数据库链接 DRUGMANA.ARTICLE_CODE 不存在Article_code是Article@DrugMana中的一个字段啊,
这是什么问题?