sql programming?
Posted Thursday, October 22, 2009 by admin
Posted Thursday, October 22, 2009 by admin
i know sql server programming.
i think ms sql s somewhat similar to this.
what about oracle programming.
is that similar to sql server programming.
i wish to learn that. can anyone suggest me a good ebook.
Posted in Programming & Design
Copyright © 2010 Ebook program
Design by ID Themes
sql is the language used in databases.
every database application has their own little SQL type
SQL Server (the one you think you know) uses Trans-ACT whilst Oracle uses some other one (My-SQL), however, the principles are generally the same. Maybe some syntax differences.
SQL (pronounced ess-que-ell, not see’qwl) is an industry-standard language specifically designed to enable people to create databases, add new data to databases, maintain the data, and retrieve selected parts of the data. Various kinds of databases exist, each adhering to a different conceptual
model. SQL was originally developed to operate on data in databases that follow the relational model. Recently, the international SQL standard has incorporated part of the object model, resulting in hybrid structures called object-relational databases.
Here is a link for a tutorial if you want to learn more.
Hope this helps…
Well sql is used in every DBMS for storing,retrieving or manipulating data.
Most DBMS have almost similiar SQL syntax with very minor differences mainly in defining keys or triggers. I recently used MySQL for one of my projects and I used a book of Oracle!!!
But then Oracle is much more than SQL. The command window SQLPLUS* for SQL itself has several functions. Besides PLSQL is an Oracle extension to SQL.
Book by Evan Bayross is a good one. You can always find an ebook for it.
A lot of confusion arises because of how these apps name their transaction programming languages.
SQL (structured query language) is an industry standard used by all the major relational DBMS (Access, Oracle, DB2, MySQL, SQL Server, etc.) A given set of SQL code defines some action to either modify a database object (CREATE TABLE, DROP VIEW, etc.) or retrieve/modify data within the database (SELECT,INSERT,etc.) With the exception of the occasional app-specific extension, the syntax of SQL doesn’t vary from app to app…a SELECT is a SELECT regardless of whether it’s in Access or Oracle.
The various transaction languages are app-specific (PL/SQL for Oracle, T-SQL for SQL Server, etc.). What they do is allow creation of procedural scripts which can include SQL code surrounded by logic controlling the circumstances under which the SQL code is executed, as well as methods for communicating with the user. The SQL code may be relatively static with only specific parameters being inserted (typically comparison values in a WHERE clause) or dynamic where the entire SQL string is pieced together based upon the execution of the script. These procedural langages are often similar, but the exact syntax will vary from app to app.