I am trying to conert a SQL Server (2000) database to Oracle to see if
it is a supportable back end for my product. I am running into a
stone wall with Stored Procedures though. I was wondering if someone
could explain a simple way to turn this T-SQL statement into a Oracle
PL/SQL statement:
CREATE PROCEDURE [CrossTab - Bench Sheet]
@BSID Int
AS
SELECT BenchSheets.*
FROM BenchSheets
WHERE BS_ID=@BSID
I can't seem to find an easy way to do it and documentation isn't very
helpful. If using a Stored Procedure is the wrong way I am open to
any alternative to running a "Select" statement with a parameter to
filter down.
I appreciate any input, 3 4049
What's the purpose? To return the values? Then you might want to create a
function that returns the table...
here's the proc version....
create procedure CrossTab_BenchS heet (vi_bsid number)
as
begin
select *
from BenchSheets
where bsid = vi_bsid;
end;
/
"Jevon" <je**********@h otmail.com> wrote in message
news:34******** *************** ***@posting.goo gle.com... I am trying to conert a SQL Server (2000) database to Oracle to see if it is a supportable back end for my product. I am running into a stone wall with Stored Procedures though. I was wondering if someone could explain a simple way to turn this T-SQL statement into a Oracle PL/SQL statement:
CREATE PROCEDURE [CrossTab - Bench Sheet] @BSID Int AS SELECT BenchSheets.* FROM BenchSheets WHERE BS_ID=@BSID
I can't seem to find an easy way to do it and documentation isn't very helpful. If using a Stored Procedure is the wrong way I am open to any alternative to running a "Select" statement with a parameter to filter down.
I appreciate any input, je**********@ho tmail.com (Jevon) wrote in message news:<34******* *************** ****@posting.go ogle.com>... I am trying to conert a SQL Server (2000) database to Oracle to see if it is a supportable back end for my product. I am running into a stone wall with Stored Procedures though. I was wondering if someone could explain a simple way to turn this T-SQL statement into a Oracle PL/SQL statement:
CREATE PROCEDURE [CrossTab - Bench Sheet] @BSID Int AS SELECT BenchSheets.* FROM BenchSheets WHERE BS_ID=@BSID
I can't seem to find an easy way to do it and documentation isn't very helpful. If using a Stored Procedure is the wrong way I am open to any alternative to running a "Select" statement with a parameter to filter down.
I appreciate any input,
I don't know T-SQL that well, but maybe I can help.
What does [CrossTab - Bench Sheet] mean? It it returning results of
the query as a crosstab or something? Does it return a cursor to the
caller?
Can you show us what the Benchsheet table looks like and an example of
what the output is supposed to look like?
Dave da**********@ya hoo.com (Dave) wrote in message news:<5e******* *************** ****@posting.go ogle.com>... je**********@ho tmail.com (Jevon) wrote in message news:<34******* *************** ****@posting.go ogle.com>... I am trying to conert a SQL Server (2000) database to Oracle to see if it is a supportable back end for my product. I am running into a stone wall with Stored Procedures though. I was wondering if someone could explain a simple way to turn this T-SQL statement into a Oracle PL/SQL statement:
CREATE PROCEDURE [CrossTab - Bench Sheet] @BSID Int AS SELECT BenchSheets.* FROM BenchSheets WHERE BS_ID=@BSID
I can't seem to find an easy way to do it and documentation isn't very helpful. If using a Stored Procedure is the wrong way I am open to any alternative to running a "Select" statement with a parameter to filter down.
I appreciate any input,
I don't know T-SQL that well, but maybe I can help.
What does [CrossTab - Bench Sheet] mean? It it returning results of the query as a crosstab or something? Does it return a cursor to the caller?
Can you show us what the Benchsheet table looks like and an example of what the output is supposed to look like?
Dave
Sorry, stupid question. That's the name of the procedure. I've been
too focused on Oracle syntax lately. :~) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mike Landis |
last post by:
Hello,
Has anyone a small tool or somekind of document which could help me
to convert Oracle SQL scripts to SQL Server?
Scripts are not very Oracle specified.
Thanks,
Below is a Script that I would e.g convert to MS SQLServer:
|
by: Thomas R. Hummel |
last post by:
Hello,
I am currently in the process of converting an Oracle data warehouse
over to SQL Server. The warehouse is loaded through a bunch of text
files all through SQL Loader, using various control files. I need to
convert this over to use BCP with format files, which has proven to be
a very tedious task.
Has anyone written, or seen, a utility to convert Oracle control files
over to format files?
|
by: Ixnay |
last post by:
Hello,
I am new to sql*server, but have used Oracle for years. Can anyone
recommend a good online guide for converting all the Oracle SQL I know
to TSQL?
tia,
Mike
|
by: DW |
last post by:
Hi, all...
I have a sizeable database running under Oracle 9.2.0.4 under AIX
5.2.0.
I am faced with an impending move to a Windows environment, running
under SQL 2000.
Currently, we are heavy users of shell scripts, for exports, backups,
etc.
|
by: sparks |
last post by:
We are slowly converting all of our older access 97 databases to 2003.
One of them that has been running fine for 3 + years and has over 2000
records in is giving me a problem. It converted fine and seems to be
ok until LOL
I add a new person and enter data....when I try to close the form it
says this record has been modified by another user and can not be
saved...then the save==copy to clipboard===drop changes box comes up.
anyone...
| |
by: Randy Reimers |
last post by:
(Hope I'm posting this correctly, otherwise - sorry!, don't know what else
to do)
I wrote a set of programs "many" years ago, running in a type of basic,
called "Thoroughbred Basic", a type of business basic. I need to re-write
it, bring it kicking and screaming to run on Windows XP. This is for a
video rental place, tracks movie and game rentals, customers, employee
transactions, reservations, does reports,..... and on.
I know some of...
|
by: iitt2007 |
last post by:
I need to convert Oracle SQL SPs and functions to SQL 2005. Table and columns names do match. Is there any tool which will 'convert' Oracle script yntax to to SQL 2005 syntax?
I can't install it on the server where DB is residing. I am looking for a standalone tool - pass input as Oracle Script and the tool spits out SQL 2005 syntax?
Any one know if such a tool is available or I need to do manual work?
Thanks.
|
by: Jevon |
last post by:
I am trying to conert a SQL Server (2000) database to Oracle to see if
it is a supportable back end for my product. I am running into a
stone wall with Stored Procedures though. I was wondering if someone
could explain a simple way to turn this T-SQL statement into a Oracle
PL/SQL statement:
CREATE PROCEDURE
@BSID Int
AS
SELECT BenchSheets.*
|
by: --CELKO-- |
last post by:
I need to convert a bunch of DB2 triggers to Oracle. Is there any
kind of tools for this?
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |