IFS PL/SQL Statements

Available templates

block

DECLARE
   |
BEGIN

END;

par

[ParameterName] IN [Datatype]

pout

[ParameterName] OUT [Datatype]

pio

[ParameterName] IN OUT [Datatype]

e

[ExceptionName] EXCEPTION;

const

[ConstantName] CONSTANT [Datatype] := [Expression];

var

[VariableName] [Datatype] := [Expression];

cur

CURSOR [CursorName] IS
   |

rt

[VariableName] [TypeName]%ROWTYPE;

num

[VariableName] NUMBER;

vc

[VariableName] VARCHAR2([VariableSize]);

bool

[VariableName] BOOLEAN;

date

[VariableName] DATE;

ex

EXCEPTION
   WHEN [ExceptionName] THEN
   |

w

WHEN [ExceptionName] THEN
   |

exo

EXCEPTION
   WHEN OTHERS THEN
   |

wo

WHEN OTHERS THEN
   |

pl

dbms_output.put_line(|);

trp

Trace_SYS.Put_Line(|);

case

CASE [VariableName]
   WHEN [Expression] THEN
   |
END CASE;

close

CLOSE [CursorName];

fetch

FETCH [CursorName] INTO [VariableName];

forall

FORALL [LoopVariableDeclaration] IN [BondsClause]

if

IF [Expression] THEN
   |
END IF;

elsif

ELSIF [Expression] THEN
   |

el

ELSE
   |

loop

LOOP
   EXIT [Condition];
END LOOP;

wl

WHILE [Expression] LOOP
   |
END LOOP;

for

FOR [LoopVariableDeclaration] IN [Expression] LOOP
   |
END LOOP;

forrev

FOR [LoopVariableDeclaration] IN REVERSE [Expression] LOOP
   |
END LOOP;

cfor

FOR [LoopVariableDeclaration] IN [CursorName] LOOP
   |
END LOOP;

open

OPEN [CursorName];

ofc

OPEN [CursorName];
FETCH [CursorName] INTO [VariableName];
CLOSE [CursorName];

ret

RETURN [Expression];

This page is generated from IFS Developer Studio at 2025-05-28 19:44.