Results 1 to 3 of 3

Thread: use of V$

  1. #1
    Join Date
    Oct 2004

    Unanswered: use of V$

    i encountered a V$ on one of my companies sql queries
    i was just qondering, what is its use???

    i tried to run a script without it and using it and the
    output is just the same

    for example
    select motoro_master.body_name_master.body_code
    from motoro_master.body_name_master;

    select motoro_master.V$body_name_master.body_code
    from motoro_master.V$body_name_master;

    thanks in advance....

  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    Try this link for some explanation (look at the entry for V$ Views & View). You can then investigate some more.

    But basically, you're getting the same result because the V$ view is just a query of the table.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Oct 2004
    thanks for the help!!!
    i appreciate it...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts