I just tried to run this using SQL*Plus, and received back:
SQL> select @@servername,
2 system_user,
3 db_name()
4 ;
select @@servername,
*
ERROR at line 1:
ORA-00936: missing expression
I very new to Oracle/SQL, and have the Oracle 10g home edition
running on a XP machine, if that matters. Just curious as why
it didn't return the expected information.
Thanks
GG
>Nick,
>
>They're trying to get at the credentials of your server, you can run the
>query yourself in a query window like so:
>
>select @@servername,
> system_user,
> db_name()
>
>you'll notice is spits back the server name, system username and the
>database name.
>
>Rob
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3189
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
