Re: what does @? in sql mean?

"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