begin plsql
Declare
v_model_name varchar(40);
begin
select bs.parent into v_model_name
from sfis1.c_bom_structure_t bs
where bs.parent ='SCVCD-SASA'
and bs.bubble_number = 300
and rownum =1;
if v_model_name is not null then
Dbms_Output.put_line(v_model_name);
else
Dbms_Output.put_line('No Model Found now');
end if;
end;[@more@]Declare
v_model_name varchar(40);
begin
select bs.parent into v_model_name
from sfis1.c_bom_structure_t bs
where bs.parent ='SCVCD-SASA'
and bs.bubble_number = 300
and rownum =1;
if v_model_name is not null then
Dbms_Output.put_line(v_model_name);
else
Dbms_Output.put_line('No Model Found now');
end if;
end;
v_model_name varchar(40);
begin
select bs.parent into v_model_name
from sfis1.c_bom_structure_t bs
where bs.parent ='SCVCD-SASA'
and bs.bubble_number = 300
and rownum =1;
if v_model_name is not null then
Dbms_Output.put_line(v_model_name);
else
Dbms_Output.put_line('No Model Found now');
end if;
end;[@more@]Declare
v_model_name varchar(40);
begin
select bs.parent into v_model_name
from sfis1.c_bom_structure_t bs
where bs.parent ='SCVCD-SASA'
and bs.bubble_number = 300
and rownum =1;
if v_model_name is not null then
Dbms_Output.put_line(v_model_name);
else
Dbms_Output.put_line('No Model Found now');
end if;
end;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/93029/viewspace-1027999/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- begin use english in my daily lifeAI
- 使用begin backup備份資料庫資料庫
- [翻譯]What You Need to Begin iOS ProgrammingiOS
- 【開發篇plsql】plsql遊標SQL
- MySQL:begin後事務為什麼不提交MySql
- 用begin backup的方式遷移資料庫資料庫
- 【SQLServer】linked server "" was unable to begin a distributed transaction.SQLServer
- 【開發篇plsql】plsql物件型別SQL物件型別
- oracle plsql(二)_plsql塊內之**冪OracleSQL
- oracle plsqlOracleSQL
- PLSQL questionsSQL
- plsql tnsnamesSQL
- 【開發篇plsql】plsql事務處理SQL
- Oracle備份與恢復系列(三)alter tablspace begin backupOracle
- plsql配置使用SQL
- plsql use skillsSQL
- PLSQL Developer 14SQLDeveloper
- oracle plsql例子OracleSQL
- plsql逐行累加SQL
- PLSQL_PROFILESQL
- plsql建立jobSQL
- 【開發篇plsql】plsql資料型別(二) recordSQL資料型別
- 儲存過程定義多個遊標多個begin儲存過程
- 業務中出現plsql打頭的表_plsql_profilter_runsSQLFilter
- PLSQL Developer 行號SQLDeveloper
- PLSQL程式語言SQL
- PLSQL Developer配置使用SQLDeveloper
- PLSQL的變數SQL變數
- plsql提交請求SQL
- PLSQL程式設計SQL程式設計
- PLSQL常用設定SQL
- plsql插入圖片SQL
- log4plsqlSQL
- PLSQL中文亂碼SQL
- plsql generate xml functionSQLXMLFunction
- windows安裝plsqlWindowsSQL
- 【開發篇plsql】plsql資料型別(一) 集合型別SQL資料型別
- Oracle OCP 1Z0 053 Q559(Alter Database Begin Backup)OracleDatabase