0
PL\SQL is an Oracle product (the PL stands for procedural language), while Sql Server most commonly refers to Microsoft SQL Server, although at one point Sybase also marketed its product as Sql Server. Microsoft and Sybase both have a procedural language feature, called T-SQL (Transact-SQL), which is similar in concept to PL\SQL, but there are significant differences in syntax and structure. An experienced developer could convert PL\SQL to T-SQL readily, but conversion would be required. It would not run without conversion.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What is the difference between sql and pl-sql?
Platform dependency-The primary difference is with respect to platform dependency, SQL is basically limited to the Windows platform where as Oracle is operable on multiple platforms such as Windows, UNIX and Linux etc. This multi-platform compatibility of Oracle makes it a universal enterprise solution, which makes it mandatory for the Oracle DBA to be acquainted with the different platforms where as the Sql DBA just needs to be familiar with the windows platform..Clustering technology-Oracle is significantly ahead of its opponent when it comes to clustering technology, Oracle makes use of RAC technology which enables two instances to act on the same data in active-active configurations.Locking and concurrency -Oracle had a multi-version consistency model which means that "readers don't block writers and writers don't block readers." Sql on the other hand has a very simple locking mechanism which follows the rule that "writers block readers and readers block writers."File system-Oracle includes IFS (Internet File System), Java integration, SQL is more of a pure database.Replication -SQL Server provides a far more simple and flexible system for replication and synchronizing of data when compared to Oracle, it involves a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.Administration-SQL server GUI is simple and easy to work with where as the Oracle server is not very user friendly as most of it command line is based.by....... Sankar
What is embedded sql?
Embedded SQL is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL. Embedded SQL statements are SQL statements written inline with the program source code of the host language. The embedded SQL statements are parsed by an embedded SQL preprocessor and replaced by host-language calls to a code library. The output from the preprocessor is then compiled by the host compiler. This allows programmers to embed SQL statements in programs written in any number of languages such as: C/C++, COBOL and Fortran.The ANSI SQL standards committee defined the embedded SQL standard in two steps: a formalism called Module Languagewas defined, then the embedded SQL standard was derived from Module Language.[1] The SQL standard defines embedding of SQL as embedded SQL and the language in which SQL queries are embedded is referred to as the host language. A popular host language is C. The mixed C and embedded SQL is called Pro*C in Oracle and Sybase database management systems. In the PostgreSQL database management system this precompiler is called ECPG. Other embedded SQL precompilers are Pro*Ada, Pro*COBOL, Pro*FORTRAN, Pro*Pascal, and Pro*PL/I.
What is High Level Language Programs?
High-level language programming is usually a mixture of words or phrases of the English language. High-level languages have several advantages over machine or assembly languages; they are easier to learn and use, and the resulting programs are easier to read and modify. A few of the High-level programs are Ada, ALgol, BASIC, COBOL, C, C++, FORTRAN, LISP, Pascal and also Prolog.
What IRQ does LPT1 usually use?
LTP1 should use IRQ7.
In what language is the Allegro PL website?
Allegro pl is in polish. If you want to change the language translate the webpage in Chrome for example by choosing “translate to English” after clicking the right button of the mouse or you can google @parcelpoland and use Poland Package Forwarding And Polish Address service.
What is precompiler in oracle?
The Oracle Precompilers are used to process C, COBOL, or PL/I programs before passing them to their native compilers. Oracle Precompilers translate embedded SQL statements in the programs into the appropriate native language statements and calls necessary to access the Oracle9i database server.
Difference between Object-based Data Model and Record-based Data Model?
Object-based data model represents data as objects with attributes and methods, providing a way to model real-world entities in a programming language like Java. On the other hand, record-based data model organizes data into fixed-format records or tuples, typically used in databases like SQL to store and retrieve structured information. Object-based data model offers a more dynamic and flexible way to represent data compared to the rigid structure of record-based models.
What is PLSQL?
The Oracle Corporation's application development language is PL/SQL. It is a superset of SQL that uses standard programming-language to supplement the SQL. PL/SQL stands for Procedural Language/Structured Query Language.
Who is Denis Orlov?
He is excellent PL/SQL programmer
Which language is used to develop the oracle?
pl/sql
Is PL or SQL is one of the version of oracle?
PL usually stands for a file extension for PERL. SQL is a database structure and querying LANGUAGE. Oracle is a software manufacturer that creates TOOLS for its own SQL database engines.
How to define a user defined function in SQL?
Not possible in SQL, but possible in many vendor-specific SQL-based languages like Oracle PL/SQL.
What is procedure oriented programming?
A language which supports sub programs. In procedural languages emphasis is more on code than data eg: COBOL,PL/SQL.
What is the difference between sql server and ms sql 2000 database?
SQL Server is most often referred to as Microsoft SQL Server, but there is also a Sybase SQL Server which was originally created on UNIX in 1987. MS sql 2000 database, or Microsoft SQL Server 2000 is a database server product. So, when you ask what is the difference, I do not see a difference, they are one in the same. Unless your question is asking for the difference between the Sybase version and Microsoft version, or you are wanting to compare different versions of Microsoft SQL Sever. In which case, I think your question must be more specific. arnel... SQL stands for (Structured Query Language). A SQL server can cover a host of products. Oracle is a SQL server however when speaking of Oracle people usually refer to it is Oracle. The server in fact is a SQL server. Microsoft SQL server is often simply referred to as SQL Server not because they 'own' the product or anything, just because of the popularity. I can draw a parallel for you. When you own a SeaDoo watercraft (as I do) people will refer to it as a jetski, same with a Kawasaki, Polaris, or any other brand. The fact is that this name (JetSki) is used interchangable however the Kawasaki Standup model watercraft is the only true 'jetski'. Anyway there are many 'flavors' of SQL server (MYSQL, Oracle, MS SQL Server, Postgress SQL, just to name a few. You can find more information about SQL server, its history and some additional 'flavors' at this link: http://en.wikipedia.org/wiki/SQL Hope that helps. Jwilliamsoh http://jwilliamsoh.spaces.live.com/
What are the benefits of PL or SQL?
SQL and iSQL* Plus Sql is command language for communication with the Oracle server any tool or application Oracle Sql contains many extensions iSQL* Plus is an Oracle Tool that recognizes and submits SQL statements to the Oracle serverfor execution and contains its own command languageWhereas PL is Procedural Language when used in conjunction with SQL is termed PL/SQL.The benefit of PL is it gives programming and logical capability to Oracle , (in other words tight integration with Oracle) . You can create variables variables, arrays etc. and handle exceptions which are not otherwise handled but just thrown back to user in oracle.You can create a logical block of code to do specific task within databse. Functionality of SQL is quite limited when it comes to providing a flexibility of programming language, for that PL/SQL was developed. Not only you can write your code to do specific tasks and extract meaningful information from databse(by doing logical operations on set of data) but you can reuse your code when similar tasks need to be done.
Which database programming languages are supported by DB2?
Pl/sql
What has the author Kevin T Owens written?
Kevin T. Owens has written: 'Building intelligent databases with Oracle PL/SQL, triggers, and stored procedure' -- subject- s -: Oracle - Computer file -, PL/SQL - Computer program language -, Relational databases 'Building intelligent databases with Oracle PL/SQL, triggers, and stored procedures' -- subject- s -: Oracle - Computer file -, PL/SQL - Computer program language -, Relational databases
