Dear Sir:
In Oracle, I can create a procedure like following:
DECLARE
A NUMBER;
BEGIN
INSERT INTO DB1 VALUES(A);
END;
/
and I run it(a.sql) use: sqlplus user/passwd @a.sql
How I create a plpgsql that like the procedure above?
(no 'create function', 'create procedure' ..., just a procedure
that I can run?)
And how to run it?
Thank your
==================================================================
新浪網.免費 50MB 電子信箱 http://www.sinamail.com