SQL> select sysdate from dual; SQL> select user from dual; SQL> desc dual; SQL> select * from dual; SQL> select lower('Hello, World') from dual; SQL> select upper('Hello, World') from dual; SQL> select initcap('hello, world') from dual; SQL> select ename, substr(ename, -3) ...
SQL Fundamentals: Using Single-Row Functions to Customize Output使用单行函数自定义输出 Oracle Function: NVL SQL Fundamentals:Restricting and Sorting Data限制和排序数据(FROM-WHERE-SELECT-ORDER BY) SQL Fundamentals: Basic SELECT statement基本的select语句(控制操作的现实列)(FROM-SELECT) SQL Fundamentals ||...
Database PL/SQL Language Reference List of Examples List of Figures List of Tables Title and Copyright Information Preface Changes in Oracle Database PL/SQL Language Reference 12c Release 2 (12.2) 1 Overview of PL/SQL 2 PL/SQL Language Fundamentals 3 PL/SQL Data Types 4 PL/SQL Control State...
课程大纲：第一章. 编写 SQL SELECT 语句 第二章. 对数据进行限制和排序 第三章. 使用单行函数自定义输出 第四章. 使用组函数报告汇总数据 第五章. 显示多个表中的数据 第六章. 使用子查询来解析查询 第七章. 使用 SET运算符 第八章. 处理数据 第九章. 使用DDL语句创建和管理表 第十章. 管理方案对象 ...
OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition By Roopesh Ramklass 592 pages McGraw-HillApril 2014 A Complete Study System for OCA Exam 1Z0-061 Prepare for the Oracle Certified Associate Oracle Database 12 c SQL Fundamentals I exam with this Oracle Press ...
旨在帮助读者备战Oracle Certifi ed Associate Oracle Database 12c SQL Fundamentals I考试。书中的每一...
Oracle Database SQL | 1Z0-071 -- SQL 部分 Oracle Database 12c Administration |1Z0-062 --DBA管理员基础 Oracle Database 12c: AdvancedAdministration | 1Z0-063 --DBA 管理员提高 通过以上可以看出考试时间均为 120分钟,考试题量分别为 78、67、80,及格率则为 63%、64%、60%。通过下边表格则更加清晰...
"Oracle Database 11g: SQL Fundamentals I"(Oracle数据库11g:SQL基础):这本书是Oracle官方的学习指南,适合初学者入门。它涵盖了SQL查询语言的基础知识和技巧,以及如何使用Oracle数据库管理工具。 "Oracle Database 12c: The Complete Reference"(Oracle数据库12c:完全参考手册):这是一本详尽全面的Oracle数据库参考书...
The Real-Time SQL Monitoring feature (SQL Monitor) was introduced in 11g to make it easier to monitor the execution of long-running SQL statements. As of 12c this tool is part of both Oracle Enterprise Manager Cloud Control and Oracle Enterprise Manager
We assume the audience have the basic knowledge of the Oracle Database Administration fundamentals. We do not expect you to be an expert DBA, basics are fair enough. 描述 Learn all about administering Oracle Data Guard (12c and 19c) environments. You will gain hands-on experience on performin...