Re: create trigger use sql*plus

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Sat, 19 Feb 2000 05:09:29 GMT
Message-ID: <88l8i8$4g4$1_at_nnrp1.deja.com>

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

+---------------------------------------------------------------
[Quoted] | 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/
[Quoted] |   "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 - 06:09:29 CET