Oracle SQL *Plus

Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way in SQL Server 2005 to do that same by using Oracle
SQL syntax in a SQL Server 2005 query?If you use proprietary syntax like TO_CHAR/TO_DATE/TO_NUMBER/SEQUENCE etc.,
then you will have a very hard time automating that conversion to valid SQL
Server Transact-SQL. However, if your SQL is fairly standard, your code
should port without difficulty. I don't fully understand how you integrate
SQL*Plus and Access using a pass-through query, but as far as syntax is
concerned, it either works or you will need to change it. I don't know of
any tools out there that will reliably change proprietary syntax from Oracle
PL/SQL to Transact-SQL or the other way. But I haven't exactly been in the
market for one of those, either. :-)
You don't need to post in HTML. Most people here won't see it that way
anyway; most of us will just get two copies of your content, which is pretty
useless, imho.
A
"Iris Faber" <Iris.Faber@.mid.state.ms.us> wrote in message
news:OsA$CqIPGHA.3924@.TK2MSFTNGP14.phx.gbl...
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access
database. Is there a way in SQL Server 2005 to do that same by using Oracle
SQL syntax in a SQL Server 2005 query?
----
--
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access
database. Is there a way in SQL Server 2005 to do that same by using Oracle
SQL syntax in a SQL Server 2005 query?|||Do you want to access data on an Oracle server from SQL Server through a lin
ked server? If so, check
out the OPENQUERY function. If the data will actually be stored on the SQL s
erver, then see Aaron's
post. And, MS has released (I believe), a tool to assist in Oracle to SQL Se
rver migration.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Iris Faber" <Iris.Faber@.mid.state.ms.us> wrote in message
news:OsA$CqIPGHA.3924@.TK2MSFTNGP14.phx.gbl...
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?
----
--
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?|||Yes, I want to access on an Oracle server from the SQL Server. Specifically
save as views. Right now when the data is pulled, it is very slow. I have
found that in Access if I change the SQL syntax to be Oracle SQL syntax by
creating a SQL Pass Thru Query, it pulls the data faster.
Do you want to access data on an Oracle server from SQL Server through a lin
ked server? If so, check
out the OPENQUERY function. If the data will actually be stored on the SQL s
erver, then see Aaron's
post. And, MS has released (I believe), a tool to assist in Oracle to SQL Se
rver migration.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Iris Faber" <Iris.Faber@.mid.state.ms.us> wrote in message
news:OsA$CqIPGHA.3924@.TK2MSFTNGP14.phx.gbl...
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?
----
--
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?|||Then you should use the OPENQUERY function, which allow you to do pass-throu
gh.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Iris Faber" <Iris.Faber@.mid.state.ms.us> wrote in message
news:eFZk4$IPGHA.3576@.TK2MSFTNGP15.phx.gbl...
Yes, I want to access on an Oracle server from the SQL Server. Specifically
save as views. Right
now when the data is pulled, it is very slow. I have found that in Access i
f I change the SQL
syntax to be Oracle SQL syntax by creating a SQL Pass Thru Query, it pulls t
he data faster.
Do you want to access data on an Oracle server from SQL Server through a lin
ked server? If so, check
out the OPENQUERY function. If the data will actually be stored on the SQL s
erver, then see Aaron's
post. And, MS has released (I believe), a tool to assist in Oracle to SQL Se
rver migration.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Iris Faber" <Iris.Faber@.mid.state.ms.us> wrote in message
news:OsA$CqIPGHA.3924@.TK2MSFTNGP14.phx.gbl...
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?
----
--
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?
----
--
Yes, I want to access on an Oracle server from the SQL Server. Specifically
save as views. Right
now when the data is pulled, it is very slow. I have found that in Access i
f I change the SQL
syntax to be Oracle SQL syntax by creating a SQL Pass Thru Query, it pulls t
he data faster.
Do you want to access data on an Oracle server from SQL Server through a lin
ked server? If so, check
out the OPENQUERY function. If the data will actually be stored on the SQL s
erver, then see Aaron's
post. And, MS has released (I believe), a tool to assist in Oracle to SQL Se
rver migration.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Iris Faber" <Iris.Faber@.mid.state.ms.us> wrote in message
news:OsA$CqIPGHA.3924@.TK2MSFTNGP14.phx.gbl...
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?
----
--
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?|||Ok, I will research on that. Thanks a lot!
Then you should use the OPENQUERY function, which allow you to do pass-throu
gh.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Iris Faber" <Iris.Faber@.mid.state.ms.us> wrote in message
news:eFZk4$IPGHA.3576@.TK2MSFTNGP15.phx.gbl...
Yes, I want to access on an Oracle server from the SQL Server. Specifically
save as views. Right
now when the data is pulled, it is very slow. I have found that in Access i
f I change the SQL
syntax to be Oracle SQL syntax by creating a SQL Pass Thru Query, it pulls t
he data faster.
Do you want to access data on an Oracle server from SQL Server through a lin
ked server? If so, check
out the OPENQUERY function. If the data will actually be stored on the SQL s
erver, then see Aaron's
post. And, MS has released (I believe), a tool to assist in Oracle to SQL Se
rver migration.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Iris Faber" <Iris.Faber@.mid.state.ms.us> wrote in message
news:OsA$CqIPGHA.3924@.TK2MSFTNGP14.phx.gbl...
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?
----
--
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?
----
--
Yes, I want to access on an Oracle server from the SQL Server. Specifically
save as views. Right
now when the data is pulled, it is very slow. I have found that in Access i
f I change the SQL
syntax to be Oracle SQL syntax by creating a SQL Pass Thru Query, it pulls t
he data faster.
Do you want to access data on an Oracle server from SQL Server through a lin
ked server? If so, check
out the OPENQUERY function. If the data will actually be stored on the SQL s
erver, then see Aaron's
post. And, MS has released (I believe), a tool to assist in Oracle to SQL Se
rver migration.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Iris Faber" <Iris.Faber@.mid.state.ms.us> wrote in message
news:OsA$CqIPGHA.3924@.TK2MSFTNGP14.phx.gbl...
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?
----
--
Currently, I use Oracle SQL *Plus to create pass thru queries in an Access d
atabase. Is there a way
in SQL Server 2005 to do that same by using Oracle SQL syntax in a SQL Serve
r 2005 query?