# fmartproc

**Repository Path**: unmasks/fmartproc

## Basic Information

- **Project Name**: fmartproc
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-09-24
- **Last Updated**: 2021-09-24

## Categories & Tags

**Categories**: Uncategorized

**Tags**: proc开发demo

## README

# 1.配置vscode的c开发环境
https://www.zhihu.com/question/333233461/answer/758817084  

# 2.下载oracleSDK（不需要安装oracle客户端）
全版本库：  
https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html

本次采用12.2版本：  
basic库：  
https://download.oracle.com/otn/nt/instantclient/122010/instantclient-basic-windows.x64-12.2.0.1.0.zip

sqlplus：  
https://download.oracle.com/otn/nt/instantclient/122010/instantclient-sqlplus-windows.x64-12.2.0.1.0.zip

headFile：  
https://download.oracle.com/otn/nt/instantclient/122010/instantclient-sdk-windows.x64-12.2.0.1.0.zip


proc：  
https://download.oracle.com/otn/nt/instantclient/122010/instantclient-precomp-windows.x64-12.2.0.1.0.zip


将上面的这几个zip文件下载并解压到（配置文件中用到此路径）：
```
D:\openSoft\instantclient_12_2
```
# 3.修改pcscfg.cfg
+ **增加window环境变数**
```
ORACLE_SDK=D:\openSoft\instantclient_12_2
MINGW_HOME=D:\openSoft\msys\mingw64
```
+ **修改**
D:\openSoft\instantclient_12_2\precomp\admin\pcscfg.cfg  
`追加下面的include`
```
include=%ORACLE_SDK%/sdk/include
include=%MINGW_HOME%/x86_64-w64-mingw32/include,
include=%MINGW_HOME%/include,
include=%MINGW_HOME%/lib/gcc/x86_64-w64-mingw32/10.2.0/include
```

# 4.创建用户
```sql
-- 管理员链接
sqlplus sys/Oradoc_db1@//localhost:1521/ORCLCDB.localdomain as sysdba

-- 创建普通用户
create user user01 identified by user01;
```

# 5.给用户授权
```sql
grant dba to user01; --授予 DBA 权限  
grant unlimited tablespace to user01;--授予不限制的表空间  
grant select any table to user01; --授予查询任何表  
grant select any dictionary to user01;--授予 查询任何字典
```

# 6.利用新用户连接数据库
```
sqlplus user01/user01@//localhost:1521/ORCLPDB1.localdomain
```

# 7.创建数据表
```sql
CREATE TABLE employees (
    EMPLOYEE_ID NUMBER(6) NOT NULL,
    FIRST_NAME VARCHAR2(20),
    LAST_NAME VARCHAR2(25) NOT NULL,
    EMAIL VARCHAR2(25) NOT NULL,
    PHONE_NUMBER VARCHAR2(20),
    HIRE_DATE DATE NOT NULL,
    JOB_ID VARCHAR2(10) NOT NULL,
    SALARY NUMBER(8,2),
    COMMISSION_PCT NUMBER(2,2),
    MANAGER_ID NUMBER(6),
    DEPARTMENT_ID NUMBER(4),
    PRIMARY KEY(EMPLOYEE_ID)
);

INSERT INTO employees VALUES(100,'Steven','King','SKING','123',to_date('2021/09/02', 'yyyy/mm/dd'),'SALESXX',24000,NULL,NULL,90);
INSERT INTO employees VALUES(101,'Neena','Kochhar','NKOCHHAR','234',to_date('2021/09/02', 'yyyy/mm/dd'),'SALESYY',17000,NULL,100,90);
```
# 8.选择/新建一个pc文件，然后F5键执行。