set serveroutput on
/* practice 9 */
/* 1 */
create or replace procedure greet IS
begin
dbms_output.put_line('hello world');
dbms_output.put_line('today is : ' || to_char(sysdate, 'dd-MON-yy'));
dbms_output.put_line('tomorrow is : ' || to_char(sysdate + 1, 'dd-MON-yy'));
end greet;
/
execute greet;
/* 2 */
drop procedure greet;
--accept p_name prompt 'enter the name: ';
create or replace procedure greet(p_name varchar2) IS
begin
dbms_output.put_line('hello ' || p_name);
dbms_output.put_line('today is : ' || to_char(sysdate, 'dd-MON-yy'));
dbms_output.put_line('tomorrow is : ' || to_char(sysdate + 1, 'dd-MON-yy'));
end greet;
/
execute greet('neema');
【PL/SQL】 Oracle procedure: Hello world
最新推荐文章于 2024-07-09 17:22:14 发布