Open Source Tutorials - Open Source Training
Open source training & tutorials from experienced, passionate people
chrome icon firefox icon ie icon opera icon safari icon Sings in these Browsers
A- A A+

By A Web Design

Welcome, Guest
Username Password: Remember me

Independant PL/SQL queries
(1 viewing) (1) Guest
All your queries regarding PL / SQL will be solved in this forum
  • Page:
  • 1
TOPIC:

Independant PL/SQL queries

Independant PL/SQL queries 1 year, 11 months ago #4

  • charuhas
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
Hello,
Can we run same code for Functions, Procedures and Cursors on MySQL, PostgreSQL, Oracle and MS-SQL?
Charuhas Mehendale

Press any key to continue or any other key to quit...
--

Re:Independant PL/SQL queries 1 year, 11 months ago #5

  • ivanb
  • OFFLINE
  • Administrator
  • Posts: 14
  • Karma: 0
MySQL, PostGreSQL, Oracle and MS-SQL are all products that are labeled RDBMS. Hence, these tools will all understand and react correctly to ANSI SQL statements.

Functions, Procedures and Cursors are all super sets of ANSI SQL for each of these products and each product will have a specific flavor of the super set. I believe that this is how these products differentiate between themselves in the RDBMS space.

Hence, I believe that you will not be able to simply copy / paste the codespec of a function, procedure or cursor written for lets say MySQL and expect it to run without any issues on the other RDBMS products.

Re:Independant PL/SQL queries 1 year, 11 months ago #6

  • charuhas
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
So it means when you learn PL/SQL queries for one RDBMS, still you need to learn other RDBMS?
Charuhas Mehendale

Press any key to continue or any other key to quit...
--

Re:Independant PL/SQL queries 1 year, 11 months ago #7

  • charuhas
  • OFFLINE
  • Fresh Boarder
  • Posts: 7
  • Karma: 0
Let me rephrase my question.
It means that when you lean one RDBMS you will still need to learn other RDBMS for these super sets?
Charuhas Mehendale

Press any key to continue or any other key to quit...
--

Re:Independant PL/SQL queries 1 year, 11 months ago #8

  • ivanb
  • OFFLINE
  • Administrator
  • Posts: 14
  • Karma: 0
I'm afraid so.

Although the syntax and semantics do not differ hugely.

Hence, if you learn, let's say PL/SQL the super set of ANSI SQL for Oracle and you can craft Functions, Procedures, Triggers, Cursors and so on effectively in PL/SQL, you should be able to pick up related syntax and semantics of parallel products fairly easily.
  • Page:
  • 1
Time to create page: 4.69 seconds
OSV Newsletter


Receive HTML?

NOTE: To prevent subscription to the OSV newsletter, uncheck the checkbox above.
Guest Blog for OSV
Free Ebook Download