Forum Stats

  • 3,874,659 Users
  • 2,266,761 Discussions
  • 7,911,932 Comments

Discussions

Help with linking tables

728051
728051 Member Posts: 1
edited Oct 14, 2009 6:09PM in General Database Discussions
Hello,

I am not really sure if this is a site that this question should be asked but I have done alot of searching and can't seem to find an answer so....

I work for a large company that uses Oracle for its databases.

In my department we use access link tables to look at the Oracle data.

In one such database I need to link to the oracle tables but only see certain data when I open the link (like a fliter).

I have no idea how to do this...I just know it can be done.. I have heard that you can use Oracle views to do the filtering on the server side and it would only return the filtered data. I think I have to do this with SQL.

But I really dont know how to go about it.

So I am posting here hoping that you guys could help me or point me in the right direction as I don't even know what questions to ask in google :)

I will be glad to give any information you may need to help me out.

Thanks a Million.

Answers

  • Toni Lazarin
    Toni Lazarin Member Posts: 1,507
    user12063135 wrote:
    Hello,
    I have heard that you can use Oracle views to do the filtering on the server side and it would only return the filtered data. I think I have to do this with SQL.
    Thanks a Million.
    You heard it right and your thouts are are floating in the right direction.
    Use views and you will be fine.
This discussion has been closed.