Jan 26, 2015 · PL/SQL. PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation. Specialities of PL/SQL. completely portable, high-performance transaction-processing language. provides a built-in interpreted and OS independent programming environment.

Mar 21, 2012 · While MySQL does have similar components, no, you cannot use PL\SQL in MySQL. The same goes for T-SQL used by MS SQL Server. MySQL has plenty of documentation on it at their website. You'll see that both PL\SQL and T-SQL are Turing-complete, and probably provide slightly more functionality. But MySQL has plenty of ways to perform similar tasks.

Dec 16, 2009 · The pure RDBMS layers of Oracle and MSSQL offer mainly a more mature programmable environment than MySQL and InnoDB. T-SQL and PL/SQL can't be yet matched by MySQL stored procedures and triggers. The other differences are syntactic and slight semantic differences which make things easier or harder (like top 500 versus limit/offset).

Nov 21, 2009 · From the list of features you currently use, there should only be a few synctactic or semantic differences, in general easy to fix or account for. The fact that you do not use PL/SQL and/or Stored Procedures is a plus. A good rule of thumb is to try and stick to SQL-92 which most DBMSes support, in particular both Oracle and MySQL.

Aug 11, 2017 · Stored procedures were introduced in MySQL 5 so be sure to be running that version. Why do we need to temporarily change the DELIMITER? From the doc: By default, mysql itself recognizes the semicolon as a statement delimiter, so you must redefine the delimiter temporarily to cause mysql to pass the entire stored program definition to the server.

Mar 19, 2013 · SQLPlus delivers a full implementation of Oracle SQL and PL/SQL, along with a rich set of extensions. The exceptional scalability of the Oracle Database, coupled with the object-relational technology of SQL*Plus, allows you to develop your complex datatypes and objects using Oracle's integrated systems solution.

@Ben, MySQL is not a database. You may have meant that MySQL is a database management system, which naturally manages databases. But more importantly MySQL is also a language, as each DBMS needs to use a specific variant of SQL and MySQL's variant is just called MySQL. –

Nov 25, 2009 · There are a variety of things that Oracle does very well, perhaps better than any other rdbms (I don't know DB2 well enough to leave that unqualified). The clustering (RAC) is very, very good. The stored procedure language, PL/SQL, is very solid and actually enjoyable to code in. There is good XML functionality, GIS, full-text, etc.

Sep 18, 2008 · restart mysql - sudo /etc/init.d/mysql restart • Start sqldev and create a new connection. a. user = root. b. pass = (your mysql pass) c. Choose MySql tab. i. Hostname = the linux IP hostname ii. Port = 3306 (default for mysql) iii. Choose Database = (from pull down the mysql database you want to use) iv. save and connect

T-SQL and PL/SQL are two completely different programming languages with different syntax, type system, variable declarations, built-in functions and procedures, and programming capabilities. The only thing they have in common is direct embedding of SQL statements, and storage and execution inside a database.