plsql.acp

editplus的SQL模板 editplus的SQL模板

#TITLE=PL/SQL
; EditPlus Auto-completion file v1.0 written by Moshe Nativ.
; This file is provided as a default auto-completion file for Oracle PL/SQL.
#CASE=n

; BLOCK
#T=<<
<<^!>>
#T=declare
DECLARE
   ^!;
BEGIN
   ^!;
END;
#T=begin
BEGIN
   ^!;
END;
#T=end
END;
#T=exception
EXCEPTION
   WHEN ^! THEN
      ;
   WHEN OTHERS THEN
      ROLLBACK;
END;
#

; CURSOR
#T=cursor
CURSOR ^! IS
   ;
#T=open
OPEN ^!;
#T=fetch
FETCH ^! INTO ;
#T=close
CLOSE ^!;
#

; DML (Basic Syntax)
#T=select
SELECT ^!
INTO 
FROM
WHERE ;
#T=insert
INSERT INTO ^! 
VALUES();
#T=update
UPDATE ^!
SET
WHERE ;
#T=delete
DELETE ^!
FROM
WHERE ;
#

; CONDITIONAL
#T=if
IF (^!) THEN
   ;
ELSIF () THEN
   ;
ELSE
   ;
END IF;
#

; ITERATION
#T=exit
EXIT WHEN ^!;
#T=loop
LOOP
   ^!;
END LOOP;
#T=while
WHILE (^!) LOOP
   ;
END LOOP;
#T=for
FOR ^! IN .. LOOP
   ;
END LOOP;
#T=forall
FORALL ^! IN .. 
   ;
#

; DYNAMIC
#T=execute
EXECUTE IMMEDIATE ^!;
#