Home » SQL & PL/SQL » SQL & PL/SQL » could trigger achieve the function?
could trigger achieve the function? [message #198780] Wed, 18 October 2006 08:49 Go to next message
Messages: 3
Registered: October 2006
Junior Member
I want to write a trigger to achieve this function that somebody can select,delete,update on a table but cann't select the special column of the table. is it possible?
Re: could trigger achieve the function? [message #198782 is a reply to message #198780] Wed, 18 October 2006 08:56 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Seems you can create a view on the table by not selecting that particular column.
And do the DML's on the view instead of the table.

Previous Topic: avg( ) over (partition by )
Next Topic: cursor help
Goto Forum:

Current Time: Wed Oct 26 06:25:21 CDT 2016

Total time taken to generate the page: 0.18442 seconds