2020年08月_Jack_LEGION

原创 SQL标准命令分类（DDL、DML、DCL）

SQL标准命令与关系数据库交互的标准SQL命令是创建、选择、插入、更新、删除和删除，简单分为以下几组：DDL（数据定义语言）数据定义语言用于改变数据库结构，包括创建、更改和删除数据库对象。用于操纵表结构的数据定义语言命令有：CREATETABLE-- 创建（在数据库中创建新表、表视图或其他对象） ALTERTABLE-- 更改（修改现有的数据库对象，如表） DROPTABLE-- 删除（删除数据库中的整个表、表或其他对象的视图）DML（数据操纵语言）数据...

2020-08-14 08:21:41 1299

原创 MySQL简介

MySQL是一个关系型数据库管理系统，由瑞典MySQL AB 公司开发，目前属于 Oracle 旗下产品。MySQL 最流行的关系型数据库管理系统，在 WEB 应用方面MySQL是最好的 RDBMS (Relational Database Management System，关系数据库管理系统) 应用软件之一。MySQL是一种关联数据库管理系统，关联数据库将数据保存在不同的表中，而不是将所有数据放在一个大仓库内，这样就增加了速度并提高了灵活性。MySQL所使用的 SQL 语言是用于访问数据库的最常用标准化

2020-08-12 09:46:42 695

转载 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 398

原创计算机专业名词（缩写、全称、中文全称）

ANSI American National Standards Institute 美国国家标准化组织 ...

2020-08-05 22:15:03 2781

转载 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 344

转载 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 325

转载查看并更改Windows系统当前使用的字符集

Changes the active console code page. If used without parameters, chcp displays the number of the active console code page.ExamplesTo view the active code page setting, type:CopychcpA message similar to the following appears: Active code page:

2020-08-02 18:42:30 863

原创 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 247

原创 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 1876

转载 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 218

转载 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 194

转载 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 148

转载 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 130

转载 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 133

转载 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 304

转载 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 199

转载 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 254

转载 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 137

转载 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 153

转载 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 282

转载 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 405

转载 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 304

转载什么是架构？什么是架构师？

什么是架构？什么是架构师？对于架构的定义，有很多种，我比较同意的一种定义是：“架构是一组关键决策”。这样的决策包括但不限于：使用什么操作系统、语言、框架与类库；是否在架构中使用某种全新的技术方案；优先考虑或满足哪一方面的需求以及如何在技术上实现这一点；更进一步的，面对一个不断发展的系统，哪些部分需要优先重构or优化、哪些决策需要重新考虑甚至修改；再进一步，某些前瞻性的考虑，也是架构决策的一部分，等到问题发生再来解决，同样是架构方面考虑不周。能够做出这些决策的，就是架构师。或者说，在一个团队中，实际

2020-08-01 12:06:10 474

Jack_LEGION的专栏