File: db-trig.sql

package info (click to toggle)
geany 2.1-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 39,300 kB
  • sloc: ansic: 168,600; cpp: 77,562; sh: 5,344; makefile: 1,694; cs: 1,233; javascript: 1,024; python: 580; f90: 537; vhdl: 504; sql: 503; lisp: 436; fortran: 389; php: 278; ada: 201; ruby: 163; java: 131; asm: 131; perl: 119; cobol: 88; tcl: 77; erlang: 73; xml: 66; ml: 27; sed: 16; pascal: 15; haskell: 6
file content (31 lines) | stat: -rw-r--r-- 969 bytes parent folder | download | duplicates (17) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
rem -----------------------------------------------------------------------
rem URL:        http://www.orafaq.com/scripts/plsql/db-trig.txt
rem Filename:   db-trig.sql
rem Purpose:    Demonstrate database triggers (available from Oracle 8i)
rem             Need DBA or CREATE ANY TRIGGER privs
rem Date:       28-Aug-1998
rem Author:     Frank Naude (frank@ibi.co.za)
rem -----------------------------------------------------------------------

create or replace trigger restrict_login
        after logon       on database
declare
        flag number := 0;
begin
        select 1 into flag from sys.v_$session where program like '%sqlplus%';
        if flag = 1 then
                raise_application_error(-20000, 'No access from sqlplus');
        end if;
end;
/
show errors


CREATE OR REPLACE TRIGGER startup_db
after startup on database
begin
    dbms_shared_pool.keep ('SYS.STANDARD','P');
    dbms_shared_pool.keep ('SYS.DBMS_STANDARD','P');
end;
/
show errors