473,320 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

triggers

Hai everyboby
i am new to this group,can one help me in triggers
could anyone help in the fallowing lines
"Database triggers can be system triggers on a database or a schema.
With a database,triggers fire for each event for all users.
With a schema,triggers fire for each event for that specifiv user."

What is the difference between trigger in a database or in a schema?
thank u in advance.
Nov 28 '06 #1
7 3732
Hi
for this u need to know what is schema.
In Oracle terminology, a user is someone who can connect to a database (if granted enough privileges) and optionally (again, if granted the appropriate privileges) can own objects (such as tables) in the database. The objects a user owns are collectively called schema.
The objects(tables,views,procedures,etc) of particular user are named something called schema

so the schema trigger means for particular user(schema).and database trigger is for all the users of database(all the schemas in database).
Nov 29 '06 #2
hai
can u help me in this please
Which three are true statements about dependent objects? (Choose three)
A. Invalid objects cannot be described.
B. An object with status of invalid cannot be a referenced object.
C. The Oracle server automatically records dependencies among objects.
D. All schema objects have a status that is recorded in the data dictionary.
E. You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.
F. You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.

ANS: I think A,D,F
but the correct answers are A,C,F
how the option D is wrong
Dec 4 '06 #3
pragatiswain
96 Expert
hai
can u help me in this please
Which three are true statements about dependent objects? (Choose three)
A. Invalid objects cannot be described.
B. An object with status of invalid cannot be a referenced object.
C. The Oracle server automatically records dependencies among objects.
D. All schema objects have a status that is recorded in the data dictionary.
E. You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.
F. You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.

ANS: I think A,D,F
but the correct answers are A,C,F
how the option D is wrong
Object status is not recoded in Data dictionary. Status can be "Vadid" or "Invalid".
Tables, sequences, and synonyms are always valid. But view, procedure, function, or package may get invalid, if the dependent objects are altered or deleted/ doesn't exist.
Lets say a Stored Procedure SP1 is dependent on Table1. If Table1 is altered or deleted/ doesn't exist, SP1 becomes invalid. That info. is stored in USER_OBJECTS.

Hope this helps
Dec 5 '06 #4
hai,
thank u very much nunnasujatha
you have given me clear idea of schema,database
Dec 5 '06 #5
hai pragathi
i think ,datadictionary stores all the information about the database
but why cant we see status in the data dictionary...
could u explain me please.........
Dec 5 '06 #6
Hai everbody
i am now preparing for OCA exam
i have so many doubts in pl/sql,could u help me ..........
Under which situation do you create a server side procedure?
A. When the procedure contains no SQL statements.
B. When the procedure contains no PL/SQL commands.
C. When the procedure needs to be used by many client applications accessing several remote
databases.
D. When the procedure needs to be used by many users accessing the same schema objects on a local
database.
can any one help me what is server side procedure?
Dec 5 '06 #7
pragatiswain
96 Expert
hai pragathi
i think ,datadictionary stores all the information about the database
but why cant we see status in the data dictionary...
could u explain me please.........
It just doesn't store the status of the objects.
Dec 5 '06 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: raulgz | last post by:
I need audit triggers that change columns value in the same record that fire trigger. I need how to do.. Thanks..
1
by: jason_s_ford | last post by:
I have several sql server databases that were recently moved to a new server. In the process of migrating the databases, any triggers and constraints attached to tables were removed on accident. ...
4
by: Mark Flippin | last post by:
I'm just starting to use triggers in my databases and find the support in Enterpise Manager lacking. Using Enterprise Manager and Query Analyzer you can maintain the triggers, but it's...
1
by: tim.pascoe | last post by:
I'm trying to generate scrips for a database, and everything so far has worked fine, except for the triggers. When I try and script existing triggers, all I get is a blank file - no SQL script. I...
4
by: stacdab | last post by:
We have a partitioned view with 4 underlying tables. The view and each of the underlying tables are in seperate databases on the same server. Inserts and deletes on the view work fine. We then...
5
by: Bruce | last post by:
I have several user defined functions which are referenced in triggers and views. For software upgrades, I need to be able to drop the triggers and views which reference these user defined...
0
by: Bruno Lavoie | last post by:
Hello, i'm etablishing a naming convention for a new project under postgresql. For tables, sequences, views, that's ok! I used good naming conventions for this in the past and i'll keep these...
0
debasisdas
by: debasisdas | last post by:
trigger sample code Ex#10 ======================= INSTEAD OF TRIGGER ---------------------------------------- create or replace trigger mytrig instead of delete or insert or update on eview...
0
debasisdas
by: debasisdas | last post by:
This thread contains some useful tips/sample codes regarding TRIGGERS in oracle, that the forum members may find useful. TRIGGERS: =============== Database trigger is a PL/SQL block that is...
4
by: --CELKO-- | last post by:
I need to convert a bunch of DB2 triggers to Oracle. Is there any kind of tools for this?
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.