Geeks Talk

Prepare for your Next Interview


Welcome to the Geeks Talk forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Oracle SQL

This is a discussion on Oracle SQL within the Oracle forums, part of the Databases category; What is virtual table?...

Go Back   Geeks Talk > Databases > Oracle
Register Blogs FAQ Tag Cloud Calendar Mark Forums Read

Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 10-16-2008
Contributing Member
 
Join Date: May 2008
Location: Chennai
Posts: 30
Thanks: 6
Thanked 0 Times in 0 Posts
sureshkumar.mtech is on a distinguished road
Smile Oracle SQL

What is virtual table?
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 10-16-2008
Junior Member
 
Join Date: Oct 2008
Location: US
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
Lynn T is on a distinguished road
Re: Oracle SQL

We used to call a subquery a virtual table. (There are several definitions for the word 'virtual', but they sort of boil down to 'Not real. Something which is virtual has no physical basis itself but mimics a physical object in conceptual terms').

By the way, I also hear people call a subquery an 'inline view'.
Reply With Quote
The Following User Says Thank You to Lynn T For This Useful Post:
  #3 (permalink)  
Old 10-20-2008
Junior Member
 
Join Date: Oct 2008
Location: chennai
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
krishnaprakashr is on a distinguished road
Re: Oracle SQL

i cannt understand virtual table.
Reply With Quote
  #4 (permalink)  
Old 11-03-2008
Expert Member
 
Join Date: Nov 2008
Location: Chennai
Posts: 303
Thanks: 1
Thanked 37 Times in 32 Posts
amitpatel66 is on a distinguished road
Re: Oracle SQL

A view is basically called a virtual table. View is nothing but a simple select query that joins more than one table and makes up to a sinlge one with the columns selected from different tables
Reply With Quote
  #5 (permalink)  
Old 08-21-2009
Junior Member
 
Join Date: Mar 2009
Location: Chennai
Posts: 28
Thanks: 0
Thanked 2 Times in 2 Posts
phanikanthmn is on a distinguished road
Wink Re: Oracle SQL

Oracle virtual table means, hidden table which doesn't occupied any storage(memory) in the database. for eg: view in oracle
Reply With Quote
  #6 (permalink)  
Old 09-12-2009
Junior Member
 
Join Date: Sep 2009
Location: hyderabad
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
pkirancse is on a distinguished road
Re: Oracle SQL

can u explain me the third normal form
Reply With Quote
  #7 (permalink)  
Old 09-13-2009
Moderator
 
Join Date: Jun 2007
Location: Bangalore,India
Posts: 1,853
Thanks: 9
Thanked 168 Times in 142 Posts
debasisdas has a spectacular aura aboutdebasisdas has a spectacular aura about
Re: Oracle SQL

read all that here
Reply With Quote
  #8 (permalink)  
Old 10-01-2009
Junior Member
 
Join Date: Oct 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
partha_pd04 is on a distinguished road
Post Re: Oracle SQL

I am not sure but I think that virtual table is a table like dual table of ORACLE which is used to store temporal data.
Reply With Quote
  #9 (permalink)  
Old 1 Week Ago
Junior Member
 
Join Date: Nov 2009
Location: hyderabad
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
sweety76 is on a distinguished road
Re: Oracle SQL

You can write your own command by using the Add Command node in the Database Expert to create a virtual table which will represent the results of processing the command.
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
what is the diffrence between oracle dba and oracle devolepler? priyanka.niksharma Oracle Certification 13 09-15-2009 04:40 PM
Oracle Apps 11i Training from Oracle University thamilesai Oracle 0 09-16-2008 03:08 AM
To select Oracle DBA or Oracle Developer? s_p_talele Career Advice 2 06-30-2008 08:08 PM
Oracle D2k and Oracle Forms & Reports jroychaudhuri Oracle 2 01-03-2008 03:10 AM
Oracle BOM or Oracle Configurator JobHelper Oracle Apps 0 05-31-2007 07:18 AM


All times are GMT -4. The time now is 06:24 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.3.1
Copyright © 2009 GeekInterview.com. All Rights Reserved