没有合适的资源？快使用搜索试试~ 我知道了~

首页Oracle Database 11g：SQL Fundamentals I1

Oracle Database 11g：SQL Fundamentals I1

oracle

1z0-051

5星 · 超过95%的资源需积分: 10 101 下载量 178 浏览量更新于2023-03-16 评论 3 收藏 3.92MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

试读

390页

Oracle Database 11g: SQL Fundamentals I V1

资源详情

资源评论

资源推荐

Oracle Database 11g: SQL

Fundamentals I

Volume II • Student Guide

D49996GC20

Edition 2.0

October 2009

D63148

Disclaimer

This document contains proprietary information and is protected by copyright and

other intellectual property laws. You may copy and print this document solely for your

own use in an Oracle training course. The document may not be modified or altered in

any way. Except where your use constitutes "fair use" under copyright law, you may

not use, share, download, upload, copy, print, display, perform, reproduce, publish,

license, post, transmit, or distribute this document in whole or in part without the

express authorization of Oracle.

The information contained in this document is subject to change without notice. If you

find any problems in the document, please report them in writing to: Oracle University,

500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not

warranted to be error-free.

Restricted Rights Notice

If this documentation is delivered to the United States Government or anyone using

the documentation on behalf of the United States Government, the following notice is

applicable:

U.S. GOVERNMENT RIGHTS

The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or

disclose these training materials are restricted by the terms of the applicable Oracle

license agreement and/or the applicable U.S. Government contract.

Trademark Notice

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other

names may be trademarks of their respective owners.

Authors

Salome Clement

Brian Pottle

Puja Singh

Technical Contributors

and Reviewers

Anjulaponni Azhagulekshmi

Clair Bennett

Zarko Cesljas

Yanti Chang

Gerlinde Frenzen

Steve Friedberg

Joel Goodman

Nancy Greenberg

Pedro Neves

Surya Rekha

Helen Robertson

Lauran Serhal

Tulika Srivastava

Editors

Aju Kumar

Arijit Ghosh

Graphic Designer

Rajiv Chandrabhanu

Publishers

Pavithran Adka

Veena Narasimhan

iii

Contents

I Introduction

Lesson Objectives I-2

Lesson Agenda I-3

Course Objectives I-4

Course Agenda I-5

Appendixes Used in the Course I-7

Lesson Agenda I-8

Oracle Database 11g: Focus Areas I-9

Oracle Database 11g I-10

Oracle Fusion Middleware I-12

Oracle Enterprise Manager Grid Control I-13

Oracle BI Publisher I-14

Lesson Agenda I-15

Relational and Object Relational Database Management Systems I-16

Data Storage on Different Media I-17

Relational Database Concept I-18

Definition of a Relational Database I-19

Data Models I-20

Entity Relationship Model I-21

Entity Relationship Modeling Conventions I-23

Relating Multiple Tables I-25

Relational Database Terminology I-27

Lesson Agenda I-29

Using SQL to Query Your Database I-30

SQL Statements I-31

Development Environments for SQL I-32

Lesson Agenda I-33

Human Resources (HR) Schema I-34

Tables Used in the Course I-35

Lesson Agenda I-36

Oracle Database 11g Documentation I-37

Additional Resources I-38

Summary I-39

Practice I: Overview I-40

1 Retrieving Data Using the SQL SELECT Statement

Objectives 1-2

Lesson Agenda 1-3

Capabilities of SQL SELECT Statements 1-4

Basic SELECT Statement 1-5

Selecting All Columns 1-6

Selecting Specific Columns 1-7

Writing SQL Statements 1-8

Column Heading Defaults 1-9

Lesson Agenda 1-10

Arithmetic Expressions 1-11

Using Arithmetic Operators 1-12

Operator Precedence 1-13

Defining a Null Value 1-14

Null Values in Arithmetic Expressions 1-15

Lesson Agenda 1-16

Defining a Column Alias 1-17

Using Column Aliases 1-18

Lesson Agenda 1-19

Concatenation Operator 1-20

Literal Character Strings 1-21

Using Literal Character Strings 1-22

Alternative Quote (q) Operator 1-23

Duplicate Rows 1-24

Lesson Agenda 1-25

Displaying the Table Structure 1-26

Using the DESCRIBE Command 1-27

Quiz 1-28

Summary 1-29

Practice 1: Overview 1-30

2 Restricting and Sorting Data

Objectives 2-2

Lesson Agenda 2-3

Limiting Rows Using a Selection 2-4

Limiting the Rows That Are Selected 2-5

Using the WHERE Clause 2-6

Character Strings and Dates 2-7

Comparison Operators 2-8

Using Comparison Operators 2-9

Range Conditions Using the BETWEEN Operator 2-10

Membership Condition Using the IN Operator 2-11

Pattern Matching Using the LIKE Operator 2-12

Combining Wildcard Characters 2-13

Using the NULL Conditions 2-14

Defining Conditions Using the Logical Operators 2-15

Using the AND Operator 2-16

Using the OR Operator 2-17

Using the NOT Operator 2-18

Lesson Agenda 2-19

Rules of Precedence 2-20

Lesson Agenda 2-22

Using the ORDER BY Clause 2-23

Sorting 2-24

Lesson Agenda 2-26

Substitution Variables 2-27

Using the Single-Ampersand Substitution Variable 2-29

Character and Date Values with Substitution Variables 2-31

Specifying Column Names, Expressions, and Text 2-32

Using the Double-Ampersand Substitution Variable 2-33

Lesson Agenda 2-34

Using the DEFINE Command 2-35

Using the VERIFY Command 2-36

Quiz 2-37

Summary 2-38

Practice 2: Overview 2-39

3 Using Single-Row Functions to Customize Output

Objectives 3-2

Lesson Agenda 3-3

SQL Functions 3-4

Two Types of SQL Functions 3-5

Single-Row Functions 3-6

Lesson Agenda 3-8

Character Functions 3-9

Case-Conversion Functions 3-11

Using Case-Conversion Functions 3-12

Character-Manipulation Functions 3-13

Using the Character-Manipulation Functions 3-14

Lesson Agenda 3-15

剩余389页未读，继续阅读

tt321jb

2012-11-15

还行，不过不是官方的

地址表程序。程序功能： 1）提示输入数字，并输入数字； 2）判断数字是否在规定的范围内，不在范围内、重新输入； 3）显示数字对应的信息，退出。 ;数据段 msg1 byte 'Chapter 1: Fundamentals',0dh,0ah,0 …… ;共有10个信息 msg byte 'Input number(1~10): ',0dh,0ah,0 table dword ;共有10个地址表元素 ;代码段 again: mov eax,offset msg call dispmsg ;提示输入 ;从键盘输入字符：EAX=数字 ;判断范围 jb again cmp eax,10 ja again ;不在范围内，重新输入 dec eax ;EAX=EAX-1 ;EAX=EAX×4 jmp table[eax] ;多分支跳转 disp1: mov eax,offset msg1 jmp disp disp2: mov eax,offset msg2 jmp disp …… disp9: mov eax,offset msg9 jmp disp disp10: mov eax,offset msg10 disp: call dispmsg ;显示

msg1 byte 'Chapter 1: Fundamentals',0dh,0ah,0 ;共有10个信息 msg byte 'Input number(1~10): ',0dh,0ah,0 table dword offset disp1, offset disp2, offset disp3, offset disp4, offset disp5, offset disp6, ...

上面代码又报错TypeError Traceback (most recent call last) C:\Users\THUNDE~1\AppData\Local\Temp/ipykernel_13868/2136795466.py in <module> 3 4 # 获取平安银行 2015 年至 2019 年的 ROE 数据 ----> 5 roe_data = jqdatasdk.get_fundamentals(jqdatasdk.query( 6 jqdatasdk.indicator.code, 7 jqdatasdk.indicator.roe).filter( D:\Anaconda\lib\site-packages\jqdatasdk\utils.py in _wrapper(*args, **kwargs) 306 raise Exception("Please run jqdatasdk.auth first") 307 else: --> 308 return func(*args, **kwargs) 309 return _wrapper 310 TypeError: get_fundamentals() got an unexpected keyword argument 'start_date'

这个错误是由于 `get_fundamentals` 函数不支持 `start_date` 和 `end_date` 这两个参数所导致的。你需要将这两个参数删除，并将查询条件改为 `jqdatasdk.valuation.code == security`，修改后的代码如下： ``` ...

chenyichen

粉丝: 2
资源: 74

上传资源快速赚钱

我的内容管理收起

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

会员权益专享

Oracle Database 11g：SQL Fundamentals I1

评论9

会员权益专享

最新资源

Oracle Database 11g：SQL Fundamentals I1

评论9

1z0-051-2 Oracle Database 11g: SQL Fundamentals I

Oracle_Database_11g_SQL_Fundamentals_II_Oracle_SQL D49994GC10

TSQLFundamentals2008.sql

ocean base 数据库书籍推荐

image processing: the fundamentals

Microsoft Certified： Fundamentals

core java, volume i: fundamentals, 12e

digital signal processing: fundamentals and applications li tan

tsqlfundamentals2008

fractional-order control systems: fundamentals and numerical implementations

fundamentals of power electronics 高清 pdf

text: fundamentals of digital logic with verilog design, third edition,

fundamentals of physics 第10版 课件

digital fundamentals10 pdf

fundamentals of database systems 7th edition

fundamentals of database systems sixth edition答案

写一份IT职业找工作简历，要求中文和英文

digital fundamentals 11th

会员权益专享

最新资源

fundamentals of physics 第10版课件