try this ... hope that will help
we assume :
- Tables and trigger are in scott's schema
- Table A col Message
- Table B col Message
- The trigger is named TRIG_HELLO , will fire BEFORE INSERT on table A and when message is 'HELLO'
CREATE OR REPLACE TRIGGER "SCOTT".TRIG_HE LLO
BEFORE INSERT ON "SCOTT"."A"
REFERENCING OLD AS OLD NEW AS NEW
...
wel
Last Activity: May 1 '07, 10:05 PM
Joined: Apr 22 '07
Location:
-
working with column privileges or
1. Create a view based on a select statement that doesn't iclude the column
2. Grant users the update privilege on that view rather then the tableLeave a comment:
-
here is juste an example to check if u've performed the right steps....
CONNECT / as sysdba;
--or anyone with the right privilege to create a user and assign the privileges
CREATE USER wel IDENTIFIED BY wel;
GRANT select ON demo.table TO wel;
CONNECT wel/wel
SELECT * FROM demo.table;
hope that we'll help youLeave a comment:
-
hi, try this
SELECT *
FROM test
WHERE (SYSDATE-test_date) BETWEEN 0 AND 91;Leave a comment:
-
hi, i do not speak english very well so ....
i don't know if it can fix the problem but when using sql*plus environment, there are a command called BREAK
Use the BREAK command to divide rows into sections and suppress duplicate values. To ensure that the BREAK command works effectively, use the ORDER BY clause to order the columns that you are breaking on.
SyntaxBREAK on column[|alias|row]...
- ClearLeave a comment:
No activity results to display
Leave a comment: