Page 1 of 2 12 LastLast
Results 1 to 20 of 22

Thread: Difference between Table, View and Synonym?

  1. #1
    Junior Member
    Join Date
    Nov 2005
    Answers
    7

    Thumbs up Difference between Table, View and Synonym?


    Hi All,


    Can anyone tell me the difference between a Table, View and Synonym.
    What is the significance of Synonym and under which situations it is used??



    Please let me know

    thanks in advance - RICHA


  2. #2
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Difference between Table, View and Synonym?

    Table is a basic unit of data storage in an oracle database. It holds all user accessible data.

    View is a virtual table
    - It can be created on a table or another view.
    - It is just like a window through which we can access or change base table data.
    - It does contain data of its own. It always takes data from its base table.
    - It is stored as a query in data dictionary.Whenever you query a view it gets data from its based table using this query.

    Main advantage of using views
    - You can ristrict access to predetermined set of rows and columns of a table
    - You can hide complexity of query
    - You can hide complexity of calculation

    Synonym is alternate name given to table, view, sequence or program unit.
    -It is used to mask real name and owner of the object.
    - You can provide public access to tables by creating public synonymns.

    Last edited by krishnaindia2007; 07-07-2008 at 03:51 AM.

  3. #3
    Junior Member
    Join Date
    Sep 2007
    Answers
    6

    Re: Difference between Table, View and Synonym?

    I Agree with krishna

    Last edited by krish_ORA; 07-07-2008 at 04:32 AM.

  4. #4
    Junior Member
    Join Date
    Jul 2008
    Answers
    2

    Re: Difference between Table, View and Synonym?

    HI Bro,
    Table :- It is a collection of row and column and it is a basic sotage unit
    view :- IT logically represents subset of data from one or more tables
    synonym :- It is Alternative name of Object


  5. #5
    Junior Member
    Join Date
    Feb 2007
    Answers
    2

    Re: Difference between Table, View and Synonym?

    hi,

    The main functionality of synonym is to access the database objects between different schema's without using the schema names.


  6. #6
    Junior Member
    Join Date
    Aug 2008
    Answers
    1

    Re: Difference between Table, View and Synonym?

    Hi this shiva prasad chitta...


    post a question if u hav any in ( c, c++, oracle )....

    ok .....
    now

    • A view is created on one or more objects (tables, views, functions) and can include more than one object type as well as more than one object (example: 3-4 tables, 1 function, 1 view can be combined together to form a single view - a logical definition). Synonyms are created on only one single object - a table, a view, a function, a stored procedure etc.
    • Not all views are updateable by definition. If a view is a single table view, it would be updateable, however, if it is comprised of complex calculations and joins, it is not directly updateable - one has to write Instead Of triggers (IO triggers) in order to make them updateable. Synonyms (when created on tables or single table views) are updateable since they are created on a single object.
    • An index can be created on a view thus forming an indexed view (SQL Server) or a materialized view (Oracle) which materializes the data to the disk - this is pretty common in data warehousing and BI applications. Synonyms are just a logical definition.
    • Synonyms (in Oracle) can be created as a public or a private synonym. For a view, one needs to specifically grant privileges since there is no such thing like a public or a private view.


  7. #7
    Junior Member
    Join Date
    Aug 2008
    Answers
    1

    Exclamation Re: Difference between cursor, ref cursor?

    Good morning everybody,

    what is the difference between cursor and ref cursor? In which circumstances we use these both and how to use?

    thankyou.


  8. #8
    Junior Member
    Join Date
    Jul 2008
    Answers
    1

    Re: Difference between Table, View and Synonym?

    hi this is raj,

    i have vb project with sql server , but now i am using oracle 9i, so the same project has to be run in xp srv pack 2, vb, oracle. where do i want to change. tell me.

    when the project runs it ask for login password for sql server.
    please


  9. #9
    Junior Member
    Join Date
    Aug 2008
    Answers
    1

    Cool Re: Difference between Table, View and Synonym?

    A table is a two- dimensoinal arrangement of data consisting of rows and columns.
    A view is a logical table that contains data collated from a database after you executes a query to retrive data from the database.The arrangement of a column in a view is different from arrangment of columns in database


  10. #10

    Re: Difference between Table, View and Synonym?

    i dont know

    Last edited by sandeep chauhan; 09-07-2008 at 07:50 AM.

  11. #11

    Re: Difference between Table, View and Synonym?

    plz answer it


  12. #12
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Difference between Table, View and Synonym?

    >>plz answer it

    Already given.

    You are expecting answer for what?


  13. #13
    Junior Member
    Join Date
    Nov 2007
    Answers
    2

    Re: Difference between Table, View and Synonym?

    table,view,synonym are called as database objects.
    A table is basic storage unit in the form of rows&columns.
    A view is a virtual table.we can restrict privileges on table by creating view.
    view is used to retrieve the data with more performance than table .
    synonym is alias name for any database object(table,view,synonym....etc)
    synonyms are more securable.


  14. #14
    Junior Member
    Join Date
    Sep 2008
    Answers
    4

    Re: Difference between Table, View and Synonym?

    Hi everybody,
    This is radhika....could u please temme

    what is a difference between procedure and a function??


  15. #15
    Junior Member
    Join Date
    Sep 2008
    Answers
    4

    Re: Difference between Table, View and Synonym?

    Quote Originally Posted by radhikakundala View Post
    Hi everybody,
    This is radhika....could u please temme

    what is a difference between procedure and a function??



  16. #16

    Re: Difference between Table, View and Synonym?

    hi,
    table contains coloumns and rows .we denote it with the name TAB_xyz,view is temp table which uses table to retrive dta fasterly.the are started with nane VW_xyz generally.and synonym are alias nasme to dtabase objects e.g- table name TABxyz then we write synonym as a.TABxyz.


  17. #17

    Re: Difference between Table, View and Synonym?

    store procedure are group of statements but it dose not returns any value.they performs only tasks while functios returns value.


  18. #18

    Re: Difference between cursor, ref cursor?

    coursors allows row by row processing of result set. disadvantage is that if select quries contain cursor then it will take more time b'se courser takes rountrip during one transation.if we fired select qury then it will take time as that of records and causes n/w conjection.


  19. #19
    Junior Member
    Join Date
    Sep 2008
    Answers
    5

    Re: Difference between Table, View and Synonym?

    Hi,
    Radhika. differance between function and procedure.
    this is very common que.
    procedure performs action.
    function returns single value.
    IN, INOUT, OUT available for procedure.
    IN and return used for function. INOUT, OUT possible in function but its very poor programing. also procedure call is possible throanother procedure or execute statement while function called by using select statement or by assigning to any value in PL/SQL block.

    Last edited by Jirange; 09-10-2008 at 08:13 AM.

  20. #20
    Junior Member
    Join Date
    Sep 2008
    Answers
    5

    Re: Difference between Table, View and Synonym?

    view is replica of table , table is oracle object has allocated memory for records in it.
    synonym is just calling alise for table name has same allocated memory existance.


Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact