Oracle Database Foundations by Bob Bryla

By Bob Bryla

The realm of it's constantly evolving, yet in each quarter there are good, middle suggestions that any one simply taking off had to recognize final 12 months, must be aware of this 12 months, and may nonetheless want to know subsequent 12 months. the aim of the principles sequence is to spot those suggestions and current them in a manner that offers you the most powerful attainable start line, it doesn't matter what your endeavor.Oracle Database Foundations presents crucial wisdom approximately fitting, configuring, retaining, and querying Oracle 9i and 10g databases. What you study right here will profit you within the brief time period, as you purchased and perform your abilities, and within the long-term, as you utilize them. themes coated contain: * easy relational database suggestions* Reporting and querying utilizing SQL*Plus and iSQL*Plus* growing and preserving a database* dealing with person entry and safety* realizing Oracle database features* utilizing a number of tables in a question* proscribing, sorting, and grouping info* Optimizing database functionality* growing backups* Troubleshooting database mistakes

Show description

Read or Download Oracle Database Foundations PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

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

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time info entry and information sharing throughout your dispensed framework utilizing the specialist info during this Oracle Press consultant. Oracle Streams 11g facts Replication explains easy methods to arrange and administer a unified company information sharing infrastructure.

Oracle Application Express 4 Recipes

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

Additional resources for Oracle Database Foundations

Example text

Check with your local DBA to see if this is the case. The user SCOTT owns a number of database tables, including the DEPT table, which contains a list of all the department numbers, department names, and department locations. As you’ll learn a little later in this chapter, the SQL SELECT statement allows you to extract information from a database. The example below shows a SELECT statement that retrieves all of the rows in the DEPT table (select * from dept;) and its results. Notice that the case of the keywords and column names is important only for readability.

This example demonstrates both the concatenation operator || and the CONCAT function. Which you use depends on how many strings are to be concatenated, as well as your programming style. If you have more than two or three strings to concatenate, using vertical bars is more readable than using the CONCAT function over and over. However, if you are dealing with translating your queries from one character set to another on a different platform, vertical bars may not translate correctly; in this case, using the CONCAT function would be the best option for concatenating any number of strings.

SQL*Plus commands must be contained entirely on one line, unless the - continuation character is used at the end of each line. The example below shows how the SQL*Plus continuation character is used: SQL> column deptno heading > “Department|Number” SQL> iSQL*Plus With iSQL*Plus, you connect to the database indirectly via a very “lightweight” middle tier. The iSQL*Plus tool is essentially the web-enabled version of 17 18 Chapter 2 thin client A workstation or CPU with relatively lowpowered components that can use a web interface (or other application with a small footprint) to connect to a middleware or a back-end database server where most of the processing occurs.

Download PDF sample

Rated 4.19 of 5 – based on 10 votes