Oracle 12c
Oracle 12c
Jack_LEGION
这个作者很懒,什么都没留下…
展开
-
Join Types (inner join、outer join、semijoins、antijoins、cartesian joins)
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgsql/joins.html#GUID-8E7760A6-48D6-4794-BF2F-290349C019B9A join type is determined by the type of join condition.This section contains the following topics:Inner Joins An转载 2020-08-05 22:57:05 · 380 阅读 · 0 评论 -
Format Models(Number Format、Datetime Format、Format Model Modifier、String-to-Date Conversion Rules)
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/Format-Models.html#GUID-DFB23985-2943-4C6A-96DF-DF0F664CED96Format ModelsAformat modelis a character literal that describes the format of datetime or numeric data sto..转载 2020-08-02 20:27:26 · 316 阅读 · 0 评论 -
Introduction to Database Startup and Shutdown
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/database-administration-with-SQL-Plus.html#GUID-E370EB32-00BD-4A53-88D2-D376B49C0F2810.2Introduction to Database Startup and ShutdownAn Oracle database may not always .转载 2020-08-02 18:40:02 · 205 阅读 · 0 评论 -
SHOW Syntax
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/SHOW.html#GUID-6BB1499D-E537-43D1-A209-401F5DB95E1612.42SHOWSyntaxSHO[W] optionwhereoptionrepresents one of the following terms or clauses:Copysystem_variabl...转载 2020-08-02 01:00:13 · 178 阅读 · 0 评论 -
SHUTDOWN Syntax
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/SHUTDOWN.html#GUID-4A4A331C-3974-491D-96EA-933A63E0544812.43SHUTDOWNSyntaxCopySHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]Shuts down a currently .转载 2020-08-02 00:58:32 · 135 阅读 · 0 评论 -
STARTUP Syntax
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/STARTUP.html#GUID-275013B7-CAE2-4619-9A0F-40DB71B61FE812.46STARTUPSyntaxSTARTUP db_options | cdb_options | upgrade_optionsExamplesTo start a CDB or non CDB ins.转载 2020-08-02 00:55:23 · 115 阅读 · 0 评论 -
Oracle 12c常用命令集合
查询当前数据库的详细版本号:1.4.2Checking Your Current Release NumberTo identify the release of Oracle Database that is currently installed and to see the release levels of other database components you are using, query the data dictionary viewPRODUCT_COMPONENT_V...原创 2020-08-02 18:41:05 · 231 阅读 · 0 评论 -
Oracle Database Quick Start (Understanding the HR Sample Schema、Connecting to the HR Schema....)
quoted from:https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/odb_quickstart/odb_quick_start.htmlUnderstanding theHRSample SchemaConnecting to theHRSchemaQuerying theHRSchemaCreating a Schema转载 2020-08-01 18:24:13 · 120 阅读 · 0 评论 -
Administrative User Accounts
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/getting-started-with-database-administration.html#GUID-79AB6187-1522-4EB7-8FAD-E4322262AC65OracleDatabase provides several administrative user accounts that are associat.转载 2020-08-01 18:13:40 · 286 阅读 · 0 评论 -
Connecting to the Database with SQL*Plus
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/getting-started-with-database-administration.html#GUID-7842AF72-DA25-4559-A8E7-9883D0C63BF2When you connect with SQL*Plus, you are connecting to the Oracle instance..转载 2020-08-01 18:10:28 · 181 阅读 · 0 评论 -
Getting Started with Oracle Enterprise Manager Express (Configuring the HTTPS Port for CDB and PDB)
Starting EM Express for non-CDBStarting EM Express for CDBStarting EM Express for PDBConfiguring the HTTPS PortAccessing the Database Home Page转载 2020-08-01 18:06:23 · 237 阅读 · 0 评论 -
SQL*Plus Globalization Support
quote from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/SQL-Plus-globalization-support.html#GUID-6582FEDC-B8EF-4F31-9696-B9E862B8DADBGlobalization support enables the storing, processing and retrieval of data in native language转载 2020-08-01 17:47:58 · 121 阅读 · 0 评论 -
Database Administration with SQL*Plus
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/database-administration-with-SQL-Plus.html#GUID-9BC1288A-BF7A-454F-9A4E-2B22699A52F6This chapter provides a brief overview of the database administration tools availab.转载 2020-08-01 17:45:26 · 135 阅读 · 0 评论 -
Installing Sample Schemas ( HR Schema )
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/comsc/installing-sample-schemas.html#GUID-1E645D09-F91F-4BA6-A286-57C5EC66321DStarting with Oracle Database 12c Release 2, the latest version of the sample schema scripts are a转载 2020-08-01 17:37:26 · 264 阅读 · 0 评论 -
Registry Parameters, About HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ntqrf/registry-parameters--overview.html#GUID-8713A684-4845-4AF2-A07B-EF3544C1D8E4HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSetcontains the following keys: Control En..转载 2020-08-01 12:54:32 · 390 阅读 · 0 评论 -
Registry Parameters, About HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_HOMENAME
quoted from:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/ntqrf/registry-parameters--overview.html#GUID-33BEB17A-6151-4192-B24B-3EABAE5A2482转载 2020-08-01 12:52:00 · 292 阅读 · 0 评论 -
Oracle 12c中的用户角色SYSDBA、SYSOPER、DBA
1) sys用户是超级用户,具有最高权限即sysdba角色,有create database的权限,所有oracle的数据字典的基表和视图都存放在sys用户中,这些基表和视图对于oracle的运行是至关重要的,由数据库自己维护,任何用户都不能手动更改。(2 ) system用户即普通dba用户角色,用于存放一级的内部数据,如oracle的一些特性或工具管理信息。该用户的默认密码是:manager 。oracle数据库中有三个较大的角色sysdba , sysoper和dba 。system用.原创 2020-08-02 18:40:29 · 1795 阅读 · 0 评论 -
Database Administrator’s Guide
Database Administrator’s Guidehttps://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/index.html-1.3SQL Statementshttps://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/getting-started-with-database-administration.html#G.转载 2020-07-14 15:52:59 · 311 阅读 · 0 评论 -
SID、
--The System Identifier (SID)The System Identifier (SID) identifies a specific database instance. The SID uniquely distinguishes the instance from any other instance on the same computer. Each database instance requires a unique SID and database name.F原创 2020-07-12 09:23:47 · 151 阅读 · 0 评论 -
Installation Guide for Microsoft Windows (Oracle 12c)
6Installing Oracle Databasehttps://docs.oracle.com/en/database/oracle/oracle-database/12.2/ntdbi/installing-oracle-database.html#GUID-640B0A1B-7417-479B-887D-382F5A6B4ED8Downloading the Installation Archive Files from Oracle Technology Networkhtt...转载 2020-08-02 18:44:14 · 309 阅读 · 0 评论 -
Oracle Database 12c Client Installation Types (Instant Client、Administrator、Runtime、Custom)
Oracle Database 12c Client Installation TypesYou can choose one of the following installation types when installing Oracle Database Client: Instant Client:Installs only the shared libraries required by Oracle Call Interface applications that use the .原创 2020-07-12 08:23:07 · 327 阅读 · 0 评论 -
Oracle 12c跟目录下NETWORK \ ADMIN\ tnsnames.ora、listener.ora、sqlnet.ora
TNS:Transparent Network SubstrateThe Oracle Transparent Network Substrate (TNS) allows for simple interdatabase communications. To implement TNS, Oracle has built a management layer over the standard network topology.原创 2020-07-13 12:56:16 · 336 阅读 · 0 评论 -
Windows 10 中sqlplus显示中文乱码
执行下面的SQL找出这3个值设置环境变量SQL> SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET');PARAMETER--------------------------------------------------------------------------------VALUE----------...原创 2020-07-11 23:31:24 · 1020 阅读 · 0 评论