Beginning Oracle SQL by Lex De Haan, Tim Gorman, Inger Jørgensen, Melanie Caffrey

By Lex De Haan, Tim Gorman, Inger Jørgensen, Melanie Caffrey (auth.)

Beginning Oracle SQL is your creation to the interactive question instruments and particular dialect of SQL used with Oracle Database. those instruments contain SQL*Plus and SQL Developer. SQL*Plus is the single instrument any Oracle developer or database administrator can continuously expect, and it's popular in developing scripts to automate regimen initiatives. SQL Developer is a robust, graphical setting for constructing and debugging queries.

Oracle's is probably the main worthwhile dialect of SQL from a occupation viewpoint. Oracle's database engine is primary in company environments all over the world. it's also present in many govt functions. Oracle SQL implements many beneficial properties no longer present in competing items. No developer or DBA operating with Oracle can manage to pay for to be with out wisdom of those positive factors and the way they paintings, as a result of the functionality and expressiveness they convey to the table.

Written in an easygoing and example-based type, Beginning Oracle SQL is the publication that may get you began down the trail to effectively writing SQL statements and getting effects from Oracle Database.

  • Takes an example-based procedure, with transparent and authoritative motives
  • Introduces either SQL and the question instruments used to execute SQL statements
  • Shows how one can create tables, populate them with facts, after which question that info to generate enterprise effects

Show description

Read Online or Download Beginning Oracle SQL PDF

Best oracle books

Oracle Database 11g PL / SQL Programming

Layout Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL purposes with professional tips from an Oracle programming specialist. With complete assurance of the newest gains and instruments, Oracle Database 11g PL/SQL Programming lays out each one subject along exact causes, cut-and-paste syntax examples, and real-world case reviews.

Oracle Weblogic Server 11gR1 PS2: Administration Essentials

This ebook is written in an easy-to-read sort, with a robust emphasis on real-world, functional examples. step by step reasons are supplied for acting very important management projects. while you are an internet server administrator searching for a brief advisor for appearing regimen and demanding WebLogic server management capabilities, together with configuring WebLogic server and deploying Java EE functions, then it is a excellent e-book for you.

Oracle database 11g : the complete reference

The Definitive advisor to Oracle Database 11gGet complete info at the robust good points of Oracle Database 11g from this completely up to date Oracle Press consultant. Oracle Database 11g: the whole Reference explains easy methods to use all of the new positive aspects and instruments, execute strong SQL queries, build PL/SQL and SQL*Plus statements, and paintings with huge gadgets and object-relational databases.

Additional info for Beginning Oracle SQL

Sample text

53 Chapter 2 ■ Introduction to SQL and SQL Developer Figure 2-25. Comparing Autotrace Writing PL/SQL The SQL Developer tool is also intended for PL/SQL development, complete with wizards, editors, compilation, and debugging. The editor for writing a function or procedure looks like Figure 2-26 and is reacheable through the left hand navigator. Just right click the node for the object type; for example, for a function, choose New Function, fill in the wizard fields, and click OK. You are now in the PL/SQL editor where you can edit, compile, compile for debug, set breakpoints, and debug.

The program now provides an extra debug bar at the top for navigating through your code while debugging. The fourth icon (the red arrow pointing into the code page) means Step Into; which is most useful for stepping one statement at a time through the code; the current statement is identifiable via the red arrow in the margin. When stepping this slowly, you have time to investigate all stages your variables go through; you are even able to see when they are NULL, that is, without value, a situation that is often the cause of wrong results.

In this example, SQL Developer is installed in C:\oracle\product\sqldeveloper and the location of the JDK will be in the subdirectory structure show in Figure 2-5. Figure 2-5. exe location When SQL Developer first starts, the Start Page shown in Figure 2-6 opens. This page includes links to documentation, to tutorials, and to the SQL Developer Forum. 36 Chapter 2 ■ Introduction to SQL and SQL Developer Figure 2-6. The SQL Developer start page ■■Note As SQL Developer is a non-licensed (free) product, support is not obtained through the MyOracleSupport site, formerly known as Metalink.

Download PDF sample

Rated 4.46 of 5 – based on 35 votes