Xem 1-20 trên 139 kết quả Features of oracle sql
  • Contents at a Glance Foreword Preface Acknowledgements 1 Introduction to Oracle SQL 2 New Features of Oracle SQL 3 Oracle Database Architecture 4 The SELECT Statement 5 Filtering Rows 6 Sorting Rows 7 Operators, Conditions, and Pseudocolumns 8 Using SQL*Plus 9 Single-Row Functions 10 Joining Tables 11 Grouping and Summarizing Data 12 Subqueries 13 Unusual Query Types 14 Expressions 15 Data Manipulation Language (DML) 1

    pdf499p bongbong_hong 19-12-2012 27 8   Download

  • SQL is a high abstraction level language used exclusively as an interface to Relational Databases. Initially it lacked recursion, and, therefore, had a limited expression power, but eventually this construct has been added to the language. Here we'll explore how convenient SQL is for general-purpose programming.

    pdf196p trinh02 28-01-2013 31 5   Download

  • Oracle SQL Tuning with SQLTXPLAIN is a practical guide to SQL tuning the way Oracle's own experts do it, using a freely downloadable tool called SQLTXPLAIN. Using this simple tool you'll learn how to tune even the most complex SQL, and you'll learn to do it quickly, without the huge learning curve usually associated with tuning as a whole. Firmly based in real world problems, this book helps you reclaim system resources and avoid the most common bottleneck in overall performance, badly tuned SQL. You'll learn how the optimizer works, how to take advantage of its latest features, and...

    pdf333p ringphone 02-05-2013 47 5   Download

  • Many times the Oracle DBA is hired once the database becomes to much to handle without one, inherits position or is appointed to it "since they are so good with computers". In any case, they usually get an undocumented system that follows no conventions and holds many traps for the unwary DBA.

    pdf0p trinh02 28-01-2013 12 3   Download

  • Enterprise JavaBean Là công nghệ nằm ở server-side Hỗ trợ đặc biệt cho các ứng dụng client-server: Xử lí giao tác (transaction) Mô hình dữ liệu phân tán Các ứng dụng portable Ưu điểm Phát triển và triển khaiứng dụng dựa trên công nghệ này dễ dàng. Tách biệt việc xử lý nghiệp vụ với hệ thống code.

    ppt26p trinh02 28-01-2013 22 8   Download

  • create user test0 identified by p123; create user test1 identified by p123; create user test2 identified by p123; create user test3 identified by p123; create user test4 identified by p123;

    ppt21p trinh02 28-01-2013 28 7   Download

  • Object orientation has now invaded traditional relational database-management systems. Oracle™ without exception has included object-oriented features in its system. SQL is now richer due to these additional features. However, the object-oriented elements in Oracle™ will not be fully utilized without a proper database design. For example, a database application designed using a traditional database modeling, such as entity-relationship (E/R) modeling, will not be able to make use of most object-oriented features in Oracle™.

    pdf345p trinh02 28-01-2013 20 6   Download

  • Here's the book you need to prepare for Exam 1Z0-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD

    pdf0p trinh02 28-01-2013 26 3   Download

  • Oracle Database Administration for Microsoft SQL Server DBAs part 1 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge.

    pdf10p pretty18 25-10-2010 160 57   Download

  • Oracle Database Administration for Microsoft SQL Server DBAs part 2 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge.

    pdf10p pretty18 25-10-2010 118 37   Download

  • Oracle PL/SQL Language Pocket Reference- P1: This pocket guide features quick-reference information to help you use Oracle's PL/SQL language. It includes coverage of PL/SQL features in the newest version of Oracle, Oracle8i. It is a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. Updated for Oracle8, that large volume (nearly 1,000 pages) fills a huge gap in the Oracle market, providing developers with a single, comprehensive guide to building applications with PL/SQL and building them the right way. ...

    pdf50p baby246 17-08-2010 76 32   Download

  • Oracle Database Administration for Microsoft SQL Server DBAs part 3 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge.

    pdf10p pretty18 25-10-2010 96 30   Download

  • A key feature of procedural programming is the ability to create and debug code quickly and easily. Procedure Builder provides all of the functionality necessary for you to successfully develop and debug PL/SQL programs. This lesson enables you to manipulate PL/SQL code using Procedure Builder. At the end of this lesson, you should be able to  Identify the advantages of developing and debugging PL/SQL programs in Procedure Builder.  Manage program units by using the Object Navigator.  Execute program units and SQL statements by using the PL/SQL Interpreter.

    pdf50p batrinh 12-08-2009 89 29   Download

  • Oracle Database Administration for Microsoft SQL Server DBAs part 4 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge.

    pdf10p pretty18 25-10-2010 114 24   Download

  • Oracle PL/SQL Language Pocket Reference- P2: This pocket guide features quick-reference information to help you use Oracle's PL/SQL language. It includes coverage of PL/SQL features in the newest version of Oracle, Oracle8i. It is a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. Updated for Oracle8, that large volume (nearly 1,000 pages) fills a huge gap in the Oracle market, providing developers with a single, comprehensive guide to building applications with PL/SQL and building them the right way. ...

    pdf50p baby246 17-08-2010 66 23   Download

  • Oracle Database Administration for Microsoft SQL Server DBAs part 6 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge.

    pdf10p pretty18 25-10-2010 98 23   Download

  • Oracle PL/SQL Language Pocket Reference- P3: This pocket guide features quick-reference information to help you use Oracle's PL/SQL language. It includes coverage of PL/SQL features in the newest version of Oracle, Oracle8i. It is a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. Updated for Oracle8, that large volume (nearly 1,000 pages) fills a huge gap in the Oracle market, providing developers with a single, comprehensive guide to building applications with PL/SQL and building them the right way. ...

    pdf50p baby246 17-08-2010 62 22   Download

  • Oracle PL/SQL Language Pocket Reference- P5: This pocket guide features quick-reference information to help you use Oracle's PL/SQL language. It includes coverage of PL/SQL features in the newest version of Oracle, Oracle8i. It is a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. Updated for Oracle8, that large volume (nearly 1,000 pages) fills a huge gap in the Oracle market, providing developers with a single, comprehensive guide to building applications with PL/SQL and building them the right way. ...

    pdf50p baby246 17-08-2010 57 22   Download

  • Oracle Database Administration for Microsoft SQL Server DBAs part 5 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge.

    pdf10p pretty18 25-10-2010 106 22   Download

  • Oracle Database Administration for Microsoft SQL Server DBAs part 35 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge.

    pdf13p pretty18 25-10-2010 116 21   Download

Đồng bộ tài khoản