Home » Server Options » Text & interMedia » Oracle Context - Solution
Oracle Context - Solution [message #76101] Mon, 05 July 2004 21:39 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

Anybody can give me a solution for the following. I'm having following tables -

Table_1
======
Region
Sales

Table_2
======
User_name
Region

Whenever a user fires a query like "Select * from Table_1" it has to return the rows which belong to his region only.

I came to know that it is possibe throgh setting CONTEXT. can anybody give me some information regarding this.

Regards,
Ronald.
Re: Oracle Context - Solution [message #76148 is a reply to message #76101] Sun, 28 November 2004 09:12 Go to previous message
Just Jonh
Messages: 4
Registered: November 2004
Junior Member
just add an additional 'WHERE cluase' to filter the results...

OR

Create a view and restict the result set to the users REGION

OR

......
Previous Topic: Multiple options in Check Constraint
Next Topic: Question on index
Goto Forum:
  


Current Time: Thu Mar 28 04:13:31 CDT 2024