5 lines
873 B
Markdown
5 lines
873 B
Markdown
```
|
|
SELECT SERIES_NO AS "序列号",CHECK_CODE AS "校验码 ",DECODE(SERVER_SERIES,'P','个人版','S','标准版','E','企业版','A','安全版 ','D','开发版') as "系列名称",DECODE(SERVER_TYPE,'1','正式版','2','测试版','3',' 试用版') as "版本类型",AUTHORIZED_CUSTOMER AS "最终用户",PROJECT_NAME AS "项目名 称",OS_TYPE AS "授权操作系统",CPU_TYPE AS "授权 CPU 类型",MAX_CPU_NUM AS "授权 CPU 个数",DECODE(CLUSTER_TYPE,'0000','无','0001','DSC','0010','RWC','0011','RWC、 DSC','0100','MPP','0101','MPP、DSC','0110','MPP、RWC','0111','MPP、RWC、 DSC','1000','DW','1001','DW、DSC','1010','DW、RWC','1011','DW、RWC、DSC','1100','DW、 MPP','1101','DW、MPP、DSC','1110','DW、MPP、RWC','1111','DW、MPP、RWC、DSC') as " 授权集群",EXPIRED_DATE AS "有效期",CONCURRENCY_USER_NUMBER AS "并发数" FROM V$LICENSE;
|
|
```
|
|
|