Home » SQL & PL/SQL » SQL & PL/SQL » help me!!
help me!! [message #37338] Thu, 31 January 2002 18:55 Go to next message
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
Messages: 82
Registered: February 2001
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

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: Thu Sep 21 11:18:14 CDT 2023