Suppose I have a table "Master" with 3 fields
Table Name: "Master"
Columns:
Type Varchar2(10)

I am wondering how Oracle deals with space in field(attribute) name? I
am figuring out the syntax to for example use in SELECT Test Table FROM
Test2, for example.
I know in SQL we can put [] around the name of the field. Can anyone

I'm a sql novice.  I'm trying to write a financial report.  I need a
sql statement that will add a range of fields (periods).  See table and
example below..
Fields: Year, Account, Period1, Period2, Period3, ..., Period12

People,
I went here:
http://www.oracle.com/education/certification/objectives/40.html
I see this topic:

We recently migrated to 9i from 8i (8.1.7.4)
Lets say T1 and T2 both have a join key column called root_key. In one
table the datatype ofr the column is varchar2(50) and in the other one
its number(18). The content is just fine.

I want to read a data-file (text) with SQL-Loader into a table. It
works fine with the exception for numerical data.
The datafield in the oracle table is defined as NUMBER(8,3) but in the
textfile I have no decimal point, only 8 characters.

When I came into work this morning, I noticed that both the ASM
instance and database instance had crashed with an "ORA-00822: MMAN
process terminated with error".
I have looked up the error and it does not give much information.  I

Database version - 8.1.7
How much data can you put in v$session_longops using
dbms_application_info?
We plan to use dbms_application_info to log the run time status of our

Platform: Oracle 9iR2 / Sun Solaris 9
Maybe this is actually a post more suited to an XML newsgroup, but does
anyone know if you can (a) embed binary data into an xml document and
(b) whether Oracle's tools using XMLTYPE will automatically handle the

I have to insert some procedures, tables and sequences from command
shell. So I try to do so using sqlplus command line coupled to a SQL
file containing all my code..
But after parsing the file, SQLplus stays up and do not give hand back

I am having a puzzling problem with connection to Oracle 9i. I
developed a code in C# but when I tried to connect to a database, it
gave me error "ORA-12514: TNS: listener could not resove SERVICE_NAME
given in connect descriptor" But on the same machine I can connect and

Hello! I need to write business justification for Oracle db server
being installed in our company. We have issue with many small Access,
Excell spreadsheet data storages, and need to have reliable and up to
date database of inventory. We also hope to have web front end access

I have 9.2 Oracle running in a  AIX 5.2 box and another 9.2 Oracle running in
a HP-UX 11.11 box.
I need make a offline backup (datafiles copy) from AIX and put in a HP-UX.
Both DBs use raw devices.

I issued following command for one of our tables (on behalf of Oracle
Enterprise Manager's Segment Advisor):
alter table "COREDATA"."SEQ_ANN" shrink space;
The command returns this error:

I am running Oracle Database 10g on RHEL4 x86_64.
The database is in use by a couple of web applications running on
ColdFusion and Tomcat application servers (on another host).
I created the '/etc/init.d/dbora script' to automatically shutdown the