Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: what does @? in sql mean?

Re: what does @? in sql mean?

From: Jason Baugher <jason_at_baugher.pike.il.us>
Date: Sun, 14 Jul 2002 16:07:01 GMT
Message-ID: <Xns924B711424812jasonbaugherpikeilus@209.242.76.10>


"zeb" <thierry.constant1_at_free.fr> wrote in news:3d317131$0$587 $626a54ce_at_news.free.fr:

> better :
> @= SID
> ?= $ORACLE_HOME

>>
>> "Sunil" <sunil_franklin_at_hotmail.com> a écrit dans le message de news:
>> 5MdY8.15$ue4.119_at_news.oracle.com...
>> > I have inherited the following code
>> >   @?/rdbms/admin/owaload.sql
>> > in a sql file
>> >
>> > what does @? mean ?
>> >
>> >
>> > Thanks,
>> > Sunil.
>> >
>> >
>> >
>> >
>> >
>>
>>

>
>

<From "Administering Oracle8i" on technet.oracle.com>

Abbreviations for ORACLE_HOME and ORACLE_SID

In Oracle8i files and programs, a question mark (?) represents the value of ORACLE_HOME. For example, Oracle8i expands the question mark in the following SQL statement to the full pathname of ORACLE_HOME:

alter tablespace TEMP add datafile '?/dbs/dbs2.dbf' size 2M

The @ sign represents $ORACLE_SID. For example, to indicate a file belonging to the current instance, enter:

alter tablespace tablespace_name add datafile 'dbsfile@.dbf'

<end quoting>

@ (and @@) are also equivalent to the START command. Take a look at the SQLPlus Users Guide and Reference (available on technet.oracle.com) to more info.

-- 
Jason Baugher 
Virtual Adept Professional Consulting Services
1406 Adams St.
Quincy, IL 62301
(217) 221-5406
http://baugher.pike.il.us/virtualadept
jason_at_baugher.pike.il.us
Received on Sun Jul 14 2002 - 11:07:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US