| abhi |
Posted: Mar 10, 2008 06:54:26 AM |
Total Post: 8
Joined: Jan, 2008
|
Please let me know hw to filter the data in a table by giving a perticular date and the steps to remove the filter given.
For ex: table has 100 records and one of the field is date filed.
How to create a filer according to date, so tat the data(records) shown is frm tat
date and not the actual datas(records).
Is there any way to view the complete data(records), when the filter is given.
And the steps to remove it.
Please let me kw regarding this.
|
|
|
 pammi |
| Posted: Mar 11, 2008 12:18:41 AM |  |
|
Total Post: 21
Joined: Feb, 2008
|
I did not clearly understand your question
If you are taking about sql environment you could filter the data using where clause in the select.
For faster retreival u could index the date coulmn
|
|
|
|
|
| Gitesh |
| Posted: Mar 13, 2008 07:58:15 AM | |
|
Total Post: 322
Joined: May, 2005
|
First way Create logon trigger and enable VPD.
Second way create FGAC with using dbms_random package which will be mask your column's data as per your requirement. Or use TRANSLATE function for masking value of column.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
