Home » SQL & PL/SQL » SQL & PL/SQL » help me!!
help me!! [message #37338] Thu, 31 January 2002 18:55 Go to next message
sujung
Messages: 1
Registered: January 2002
Junior Member
1. what are the differences between tables and views?
provide practical exaples where table s can be used and where views need to be used..

2. what are tablespaces and datafiles. can i have mulple tablespaces for one oracle dataspace.
From SR [message #37342 is a reply to message #37338] Fri, 01 February 2002 00:24 Go to previous messageGo to next message
ramu
Messages: 82
Registered: February 2001
Member
Hi Sujung,

Basic difference between a table and a view is table can store data and view is something like a window through which u peep. Views are also called logical tables. Views are not for storing datas but to retrieve datas from tables. If u have a view created based on single table then u can do dml operations based on view created.

Yes u can have several tablespaces in a orion db.
Re: From SR [message #37397 is a reply to message #37342] Wed, 06 February 2002 03:57 Go to previous message
Armani D
Messages: 19
Registered: February 2002
Junior Member
Sujung,

I suggest you get your hands on a copy of the Oracle 9i DBA handbook. It will help answer some of your elemntal Oracle questions like you posted.

Good Luck!
Previous Topic: Help - Sql statement
Next Topic: Re: to_char(sysdate, 'D') - number of the day
Goto Forum:
  


Current Time: Sun Sep 19 13:08:35 CDT 2021