| Selecting from MS SQL Server [message #179580] |
Wed, 28 June 2006 02:02  |
kmsalih
Messages: 197
Registered: March 2006
|
Senior Member |
|
|
Hi,
I want to select a function from MS SQL Server from oracle.
Created the database link which connects from oracle to MS SQL.
In SQL there is
I want to use the above statement in oracle.
I had given
Select "@@version"@dblink;
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
Any one can please solve this.
Regards
Salih KM
|
|
|
|
|
|
| Re: Selecting from MS SQL Server [message #179726 is a reply to message #179683] |
Wed, 28 June 2006 09:02  |
kmsalih
Messages: 197
Registered: March 2006
|
Senior Member |
|
|
Thanks for your reply.
But my questions is different.
If we give
in Ms SQL server, will show the version of the MS SQL Server.
Is it possible to select this from oracle (using SQL *PLus)
Regards
SALIH KM
|
|
|
|
|
|
| Re: Selecting from MS SQL Server [message #179880 is a reply to message #179867] |
Thu, 29 June 2006 03:19 |
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
|
Senior Member |
|
|
Just to clarify the question (I think) The OP wants to be able to find out the SQL SERVER version by running a script in Oracle. Unfortunately I don't know the answer to this, but I thought that the original question was being misunderstood, so hopefully someone can help out.
Jim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
