create or replace procedure insert_pro
as
begin
insert into a (b) values ('1'); --实现插入语句功能
end;
/已是最简单过程,具体问题具体分析.
as
begin
insert into a (b) values ('1'); --实现插入语句功能
end;
/已是最简单过程,具体问题具体分析.
解决方案 »
- 问一条关于LIKE的SQL语句
- 怎么才知道DB是建在哪个表空间?
- 物化视图替代临时表的问题
- dspace连接oracle问题
- 30分求高手帮忙一个算法问题(Oracle),用decode做最好。
- 除了enterprise console manager以外,sqlplus system/qazwsx@linux ,PLSQLdeveloper ,TOAD都不能访问数据库
- oracle的审计问题
- select * from sys.ruan where rownum =(select max(rownum) from sys.ruan);
- 多表查询????急
- 如何测试String 类型变量的长度
- 这个语句该怎么写
- oracle8i的卸载问题,急
REM Version 1.0, last updated 5/7/97
REM This script illustrates a stored procedure, as described in
REM Chapter 2 of _Oracle8 PL/SQL Programming_ by Scott Urman.CREATE OR REPLACE PROCEDURE InsertIntoTemp AS
/* Declare variables to be used in this block. */
v_Num1 NUMBER := 5;
v_Num2 NUMBER := 6;
v_String1 VARCHAR2(50) := 'Hello World!';
v_String2 VARCHAR2(50) := '-- This message brought to you by PL/SQL!';
v_OutputStr VARCHAR2(50);
BEGIN
/* First, insert two rows into temp_table, using the values of the
variables. */
INSERT INTO temp_table (num_col, char_col)
VALUES (v_Num1, v_String1);
INSERT INTO temp_table (num_col, char_col)
VALUES (v_Num2, v_String2);
/* Now query temp_table for the two rows we just inserted, and output
them to the screen using the DBMS_OUTPUT package. */
SELECT char_col
INTO v_OutputStr
FROM temp_table
WHERE num_col = v_Num1;
DBMS_OUTPUT.PUT_LINE(v_OutputStr);
SELECT char_col
INTO v_OutputStr
FROM temp_table
WHERE num_col = v_Num2;
DBMS_OUTPUT.PUT_LINE(v_OutputStr);
END InsertIntoTemp;
/
CREATE PROCEDURE sam.credit (acc_no IN NUMBER, amount IN NUMBER) AS
BEGIN
UPDATE accounts
SET balance = balance + amount
WHERE account_id = acc_no;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
CREATE PROCEDURE credit (acc_no IN NUMBER, amount IN NUMBER) AS
BEGIN
UPDATE accounts
SET balance = balance + amount
WHERE account_id = acc_no;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;再试试
as
begin
insert into jch_ls
select *
from jch
where name='asdf';
commit;
end;