Teach Yourself SQL in 21 Days by Jonathan Gennick

By Jonathan Gennick

Sams train your self PL/SQL in 21 Days, moment version, speedy empowers you to create your individual Oracle ideas with PL/SQL. thoroughly revised to hide Oracles 8i, the e-book offers information and path, top you thru a development of subject matters that start with the fundamental construction blocks of PL/SQL, and finishing with in-depth discussions of the probably used complex positive aspects of Oracle's database programming surroundings. New issues comprise prolonged dynamic SQL inside of PL/SQL, Dynamic SQL inside of PL/SQL, use of invoker's rights, self sufficient transactions, interfacing PL/SQL with Java, PL/SQL Bulk Binds, parameter passing by way of reference, and complicated Querying.

Show description

Read or Download Teach Yourself SQL in 21 Days PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time details entry and information sharing throughout your dispensed framework utilizing the professional info during this Oracle Press advisor. Oracle Streams 11g information Replication explains tips on how to arrange and administer a unified firm info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle program show four Recipes offers an example-based method of studying software exhibit - the ground-breaking, swift program improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply desires an exceptional instance or to kick commence their considering and get pointed within the correct path.

Additional resources for Teach Yourself SQL in 21 Days

Sample text

1 Notice that the amount 150 is repeated. What if you wanted to see how may different amounts were in this column? 34 6 rows selected. ANALYSIS: Notice that only six rows are selected. Because you specified DISTINCT, only one instance of the duplicated data is shown, which means that one less row is returned. ALL is a keyword that is implied in the basic SELECT statement. You almost never see ALL because SELECT

and SELECT ALL
have the same result. 1 7 rows selected. It is the same as a SELECT .

If the condition after the NOT is FALSE, it becomes TRUE. For example, the following SELECT returns the only two names not beginning with B in the table: INPUT: SQL> SELECT * 2 FROM VACATION 3 WHERE LASTNAME NOT LIKE 'B%'; OUTPUT: LASTNAME EMPLOYEENUM YEARS LEAVETAKEN -------------- ----------- -------- ---------ABLE 101 2 4 COSTALES 211 10 78 NOT can also be used with the operator IS when applied to NULL. Recall the PRICES table where we put a NULL value in the WHOLESALE column opposite the item ORANGES.

INPUT: SQL> SELECT * FROM SOFTBALL; OUTPUT: NAME -------------------ABLE BAKER CHARLIE DEAN EXITOR FALCONER GOOBER 7 rows selected. How many different people play on one team or another? INPUT/OUTPUT: SQL> SELECT NAME FROM SOFTBALL 2 UNION 3 SELECT NAME FROM FOOTBALL; NAME -------------------ABLE BAKER BRAVO CHARLIE DEAN DECON EXITOR FALCONER FUBAR GOOBER 10 rows selected. UNION returns 10 distinct names from the two lists. How many names are on both lists (including duplicates)? INPUT/OUTPUT: SQL> SELECT NAME FROM SOFTBALL 2 UNION ALL 3 SELECT NAME FROM FOOTBALL; NAME -------------------ABLE BAKER CHARLIE DEAN EXITOR FALCONER GOOBER ABLE BRAVO CHARLIE DECON EXITOR FUBAR GOOBER 14 rows selected.

Download PDF sample

Rated 4.40 of 5 – based on 16 votes