Re: create trigger use sql*plus

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: 2000/02/19
Message-ID: <88l8i8$4g4$1_at_nnrp1.deja.com>#1/1

We normally signal end of SQL by using ';' but in case of PLSQL (triggers, procedures, packages, blocks etc) we need to single end of our code for execution by ';' AND '/'.

This is required since we use ';' in PLSQL to signal end of statement.

regards,
M. Armaghan Saqib

+---------------------------------------------------------------
| 1. SQL PlusPlus => Add power to SQL Plus command line
| 2. SQL Link for XL => Integrate Oracle with XL

| 3. Oracle CBT with sample GL Accounting System | Download free: http://www.geocities.com/armaghan/

 +---------------------------------------------------------------
| SQLPlusPlus now on http://www.ioug.org/
|   "PL/SQL package that extends SQL*Plus to another dimension.

| Contains a PL/SQL code generator and set of extremely useful | utilites with extensive documentation." IOUG Web Site

+---------------------------------------------------------------

nice to see you <moz01_at_holmes.ipfw.edu> wrote in message news:Pine.HPX.4.10.10002181136460.5889-100000_at_holmes.ipfw.edu...
>
> Hi, is anyone know how to use sql*plus to create trigger? I tried
 it. It
> just keep give line numbers.
>
> Thank you.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Feb 19 2000 - 00:00:00 CET