General discussion

Locked

Sybase vs Oracle SQL

By KDowson ·
I have to take a Syabse stored procedure and make it work on Oracle 8i.
The procedure basically creates a temporary table which it then inserts records into based on data selected from other tables.
It then manipulates the data and returns a resultset from a final select.
Just cutting and pasting the procedure doesn't work, the Create table statement seems to be the problem.
Does anyone know of any sites with 'GOOD' examples of PL/SQL code, particularly with examples of tables data manipulation.
I am aware that this sort of procedure needs to use Dynamic SQL but I'm a real learner on all of this.
I don't want to show the code here but if anyone can help me via email I can send them the procedure.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Sybase vs Oracle SQL

by mikes In reply to Sybase vs Oracle SQL

Try technet.oracle.com

It's a free site and once you register you will have access to all the Oracle documentation and samples of code. If that doesnlt help, email me the code and I can give you some suggestions.

Mike

Collapse -

Sybase vs Oracle SQL

by KDowson In reply to Sybase vs Oracle SQL

I tried there already & didn't get much help. We went with Plan 'B' in the interim and I will be seeking some one-on-one PL/SQL training in October.

Collapse -

Sybase vs Oracle SQL

by KDowson In reply to Sybase vs Oracle SQL

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums