第十七周第二天

本文详细介绍了Linux系统中软件包管理、任务计划安排、硬盘管理及磁盘配额设置等核心内容,包括如何通过rpm/yum包管理器操作软件,使用cron安排重复性任务,以及如何添加、分区和格式化硬盘,实现外部设备的永久挂载。
 

1、软件包管理rpm yum

2、任务计划的安排at  cron

3、添加硬盘、划分磁盘配额、挂载外部设备等

 

步骤:

1、  软件包的管理

1)  以sudo为例演示依赖关系

常见的软件类型rpm

很多爱好者在某种固定的环境(硬件、软件)下进行编译;

需要使用该软件包,必须要提供和编译环境一致的环境;

解决:

  按照提示一步一步将所需环境安装完善

  将linux升级

虚拟机---VM---settings---CD/DVD---指定景象文件路径(第一张光盘)---

Device  status:

   Connected:只要有外部设备挂载,系统就会识别

   Connected power on:开机识别一次;

 

  开机:脚本----inittab

  用户:脚本----login.defs

影响挂载外部设备的脚本文件:/etc/fstab

实现永久挂载

语法格式:

l         每一行是一条记录

l         硬件设备

l         6个字段

外部设备名

挂载点

文件系统类型

限制

自检

备份(优先级别)

/dev/cdrom

/mnt

ext3

 

0

 

 

 

 

 

 

 

l         文件里包含的记录表示开机自动识别

命令行方式实现临时挂载

#mount  -t 类型  外部设备   挂载点

注意:挂载点的设置

   不建议直接映射到/mnt

   防止/mnt已经挂载了其他设备

   尽量创建新目录

   #mkdir   /mnt/u_pos

   #mkdir   /mnt/cdrom

   #mount –t ext3 /dev/cdrom  /mnt/cdrom

   #cd /mnt/cdrom

   #ls

   #umount  /dev/cdrom

 

warning: sudo-1.6.6-3.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e

表示RPM的数字签名有问题

在光盘上

#man  rpm

安装

#rpm  –ivh   sudo-版本.rpm

检测已经安装上的软件包的情况

#rpm –qa|grep sudo

删除

#rpm  -e  sudo

 

#rpm   --import   RPM-GPG-KEY

Linux ---源码

centos ----将源码编译后

 

yum:到网络上

安装

#man yum

#yum  install  软件-版本.rpm

 

 

源码安装

 

 

 

 

2、  安排任务(重复性)cron

注意区别:一次性任务at

1)  cron是通过rpm包安装的一个安排任务的工具

检测系统里是否存在cron

 

#rpm –qa|grep cron

 

2)  开启相应服务

特点:系统每隔一分钟检查相应脚本文件

 

#service  crond   start

3)  安排任务(编辑脚本)

# cat  /etc/crontab

名=值    定义环境变量

       SHELL=/bin/bash

PATH=/sbin:/bin:/usr/sbin:/usr/bin

MAILTO=root

HOME=/

                                                                               

# run-parts

01 * * * * root run-parts /etc/cron.hourly

02 4 * * * root run-parts /etc/cron.daily

22 4 * * 0 root run-parts /etc/cron.weekly

42 4 1 * * root run-parts /etc/cron.monthly

    4 2     4      1      *       *    commond

   分钟   小时   日期   月份   星期    命令

   0-59    0-23   1-31    1-12   0-6   

  #man  5  crontab

 

l       第一种安排任务的方式

到固定的目录下编辑文件

 

例如:安排系统每个小时进行复制

  #cd /etc/cron.hourly

  #vi cron.file

     4 2     4      1      *       *  cp –r /etc   /tmp

  :wq

l             第二种办法,直接使用crontab进行脚本的编进

   #vi  root

   #mv root  /var/spool/cron

 

 

#crontab –e

     -e :edit

     -r :remove

     -l :list

  安排以下任务

   每年的12月25日下午4点半 备份/etc到外部设备

   每年的12月25日下午4点到6点半 备份/etc到外部设备

   每年的12月25日下午4点10分,25分 备份/etc到外部设备

  

   两个硬盘----fdisk

 

注意:

l         各个时间点之间用空格或tab键隔开

l         表示范围  16-18

l         独立的多个时间 16,18

l         *表示任何时间点

 

     /var/spool/cron目录中增加一个以安排任务的用户名为名称的文件

该文件就是crontab  -e 编辑的那个文件

 

补充:

   /etc/init.d/crond   管理任务的脚本文件  进程文件

3、  添加硬盘---分区格式化---磁盘配额

第一步:

添加硬盘步骤

   关闭系统:否则只允许安装SCSI方式的硬盘

在虚拟机里---VM---settings----HARD---add---下一步—IDE

   重启虚拟机

       打开终端

       #fdisk  -l

       检测系统能识别到的外部硬件设备

      硬盘的连接方式有两种

      IDE

/dev/hda---表示第一块ide硬盘

   /dev/hda0---表示第一个硬盘上的一个主分区

   /dev/hda1--表示第一个硬盘上的二个主分区

   。。。

/dev/hdb---表示第2块ide硬盘

   /dev/hdb0---表示第2个硬盘上的一个主分区

   /dev/hdb1--表示第2个硬盘上的二个主分区

 

SCSI---u盘

 /dev/sda--------表示第一块scsi硬盘

   /dev/sda0---表示第一个硬盘上的一个主分区

   /dev/sda1--表示第一个硬盘上的二个主分区

。。。

/dev/sdb--------表示第一块scsi硬盘

   /dev/sdb0---表示第一个硬盘上的一个主分区

   /dev/sdb1--表示第一个硬盘上的二个主分区

 

第二步:分区

   /dev/sdb

 #fdisk   /dev/sdb

 Commond :m   -------察看帮助

 Commond :n------new

     p----创建主分区

      1-----制定分区号

        1----制定开始的柱面

        +500M----制定结束的空间大小

Commond :w------write ----保存分区情况

 

 第三步:格式化

   制定在该分区的数据保存的规则

  #man  mkfs 

#mkfs  -t   ext3   /dev/sdb1

创建文件系统

 

第四步:/dev/sdb1进行磁盘配额的限制

  #vi  /etc/fstab

     default,usrquota,grpquota

  #man  quotacheck

  #quotacheck  –cmng  /dev/sdb1

 检测某硬件设备的磁盘配额分配情况

  创建一个映射目录

  #mkdir  /var/zhy

  创建zhy用户的磁盘配额

  #man edquota

  #  zhy

  

declare v_1 date := TO_DATE('20250301', 'YYYYMMDD'); v_start date; v_end date := trunc(sysdate); v_current date; v_sql varchar2(32767); begin v_start :=trunc(v_1); for i in 0..(v_end-v_start) loop v_current := v_start+i; v_sql := 'merge into PURE_SPREAD dest using (with t1 as (SELECT a.*,CASE WHEN a.COUNTRY_CODE = ''tz'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ke'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ci'' THEN a.IN_FORCE_DATE WHEN a.COUNTRY_CODE = ''ph'' THEN a.IN_FORCE_DATE + 8 / 24 END AS NEW_DATE FROM LOAN_BORROW_INFO_TEST a WHERE a.COUNTRY_CODE <> ''gh'' AND a.RISK_SERIAL_NO <> ''googleplay'' AND a.ARCHIVED=1 and a.IN_FORCE_DATE is not null), t2 as (select distinct phone,country_code,NEW_DATE from t1 where TRUNC(NEW_DATE)=TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') and user_type_product=0), t3 as ( select t1.NEW_DATE,t1.ACTUAL_REPAYMENT_AMOUNT,t1.ACTUAL_AMOUNT,t1.state from t2 left join t1 on t2.phone=t1.phone and t2.country_code=t1.country_code and t1.NEW_DATE>=t2.NEW_DATE and t1.new_date is not null), t4 as( select week_num,TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') as pure_in_force_date,sum(rs-rl)/100 AS Spread from (SELECT case when state !=6 then ACTUAL_REPAYMENT_AMOUNT-ACTUAL_AMOUNT else 0 end as rs, case when state = 6 then ACTUAL_AMOUNT else 0 end as rl, TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7)+1 AS week_num, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 AS week_start, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 + 6 AS week_end FROM t3 WHERE NEW_DATE BETWEEN TO_DATE("2025-03-01", "YYYY-MM-DD") AND TRUNC(ADD_MONTHS(SYSDATE, 12), "YYYY") - 1) GROUP BY week_num ORDER BY week_num) select * from t4 pivot(sum(round(Spread,6)) for week_num IN (1 AS "第一", 2 AS "第二", 3 AS "第三", 4 AS "第四", 5 AS "第五", 6 AS "第六", 7 AS "第七", 8 AS "第八", 9 AS "第九", 10 AS "第十", 11 AS "第十一", 12 AS "第十二", 13 AS "第十三", 14 AS "第十四", 15 AS "第十五", 16 AS "第十六", 17 AS "第十七", 18 AS "第十八", 19 AS "第十九", 20 AS "第二十", 21 AS "第二十一", 22 AS "第二十二", 23 AS "第二十三", 24 AS "第二十四", 25 AS "第二十五", 26 AS "第二十六", 27 AS "第二十七", 28 AS "第二十八", 29 AS "第二十九", 30 AS "第三十", 31 AS "第三十一", 32 AS "第三十二", 33 AS "第三十三", 34 AS "第三十四", 35 AS "第三十五", 36 AS "第三十六", 37 AS "第三十七", 38 AS "第三十八", 39 AS "第三十九", 40 AS "第四十", 41 AS "第四十一", 42 AS "第四十二", 43 AS "第四十三"))) src on ( dest.pure_in_force_date= src.pure_in_force_date ) WHEN MATCHED THEN UPDATE SET dest."第一" = src."第一",dest."第二" = src."第二",dest."第三" = src."第三",dest."第四" = src."第四",dest."第五" = src."第五",dest."第六" = src."第六",dest."第七" = src."第七",dest."第八" = src."第八",dest."第九" = src."第九",dest."第十" = src."第十",dest."第十一" = src."第十一",dest."第十二" = src."第十二",dest."第十三" = src."第十三",dest."第十四" = src."第十四",dest."第十五" = src."第十五",dest."第十六" = src."第十六",dest."第十七" = src."第十七",dest."第十八" = src."第十八",dest."第十九" = src."第十九",dest."第二十" = src."第二十",dest."第二十一" = src."第二十一",dest."第二十二" = src."第二十二",dest."第二十三" = src."第二十三",dest."第二十四" = src."第二十四",dest."第二十五" = src."第二十五",dest."第二十六" = src."第二十六",dest."第二十七" = src."第二十七",dest."第二十八" = src."第二十八",dest."第二十九" = src."第二十九",dest."第三十" = src."第三十",dest."第三十一" = src."第三十一",dest."第三十二" = src."第三十二",dest."第三十三" = src."第三十三",dest."第三十四" = src."第三十四",dest."第三十五" = src."第三十五",dest."第三十六" = src."第三十六",dest."第三十七" = src."第三十七",dest."第三十八" = src."第三十八",dest."第三十九" = src."第三十九",dest."第四十" = src."第四十",dest."第四十一" = src."第四十一",dest."第四十二" = src."第四十二",dest."第四十三" = src."第四十三" WHEN NOT MATCHED THEN INSERT ( pure_in_force_date, "第一","第二","第三","第四","第五","第六","第七","第八","第九","第十","第十一","第十二","第十三","第十四","第十五","第十六","第十七","第十八","第十九","第二十","第二十一","第二十二","第二十三","第二十四","第二十五","第二十六","第二十七","第二十八","第二十九","第三十","第三十一","第三十二","第三十三","第三十四","第三十五","第三十六","第三十七","第三十八","第三十九","第四十","第四十一","第四十二","第四十三" ) VALUES ( src.pure_in_force_date, src."第一",src."第二",src."第三",src."第四",src."第五",src."第六",src."第七",src."第八",src."第九",src."第十",src."第十一",src."第十二",src."第十三",src."第十四",src."第十五",src."第十六",src."第十七",src."第十八",src."第十九",src."第二十",src."第二十一",src."第二十二",src."第二十三",src."第二十四",src."第二十五",src."第二十六",src."第二十七",src."第二十八",src."第二十九",src."第三十",src."第三十一",src."第三十二",src."第三十三",src."第三十四",src."第三十五",src."第三十六",src."第三十七",src."第三十八",src."第三十九",src."第四十",src."第四十一",src."第四十二",src."第四十三" )' ; EXECUTE IMMEDIATE v_sql; END LOOP; end; declare v_1 date := TO_DATE('20250301', 'YYYYMMDD'); v_start date; v_end date := trunc(sysdate); v_current date; v_sql varchar2(32767); begin v_start :=trunc(v_1); for i in 0..(v_end-v_start) loop v_current := v_start+i; v_sql := 'merge into PURE_SPREAD dest using (with t1 as (SELECT a.*,CASE WHEN a.COUNTRY_CODE = ''tz'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ke'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ci'' THEN a.IN_FORCE_DATE WHEN a.COUNTRY_CODE = ''ph'' THEN a.IN_FORCE_DATE + 8 / 24 END AS NEW_DATE FROM LOAN_BORROW_INFO_TEST a WHERE a.COUNTRY_CODE <> ''gh'' AND a.RISK_SERIAL_NO <> ''googleplay'' AND a.ARCHIVED=1 and a.IN_FORCE_DATE is not null), t2 as (select distinct phone,country_code,NEW_DATE from t1 where TRUNC(NEW_DATE)=TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') and user_type_product=0), t3 as ( select t1.NEW_DATE,t1.ACTUAL_REPAYMENT_AMOUNT,t1.ACTUAL_AMOUNT,t1.state from t2 left join t1 on t2.phone=t1.phone and t2.country_code=t1.country_code and t1.NEW_DATE>=t2.NEW_DATE and t1.new_date is not null), t4 as( select week_num,TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') as pure_in_force_date,sum(rs-rl)/100 AS Spread from (SELECT case when state !=6 then ACTUAL_REPAYMENT_AMOUNT-ACTUAL_AMOUNT else 0 end as rs, case when state = 6 then ACTUAL_AMOUNT else 0 end as rl, TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7)+1 AS week_num, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 AS week_start, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 + 6 AS week_end FROM t3 WHERE NEW_DATE BETWEEN TO_DATE("2025-03-01", "YYYY-MM-DD") AND TRUNC(ADD_MONTHS(SYSDATE, 12), "YYYY") - 1) GROUP BY week_num ORDER BY week_num) select * from t4 pivot(sum(round(Spread,6)) for week_num IN (1 AS "第一", 2 AS "第二", 3 AS "第三", 4 AS "第四", 5 AS "第五", 6 AS "第六", 7 AS "第七", 8 AS "第八", 9 AS "第九", 10 AS "第十", 11 AS "第十一", 12 AS "第十二", 13 AS "第十三", 14 AS "第十四", 15 AS "第十五", 16 AS "第十六", 17 AS "第十七", 18 AS "第十八", 19 AS "第十九", 20 AS "第二十", 21 AS "第二十一", 22 AS "第二十二", 23 AS "第二十三", 24 AS "第二十四", 25 AS "第二十五", 26 AS "第二十六", 27 AS "第二十七", 28 AS "第二十八", 29 AS "第二十九", 30 AS "第三十", 31 AS "第三十一", 32 AS "第三十二", 33 AS "第三十三", 34 AS "第三十四", 35 AS "第三十五", 36 AS "第三十六", 37 AS "第三十七", 38 AS "第三十八", 39 AS "第三十九", 40 AS "第四十", 41 AS "第四十一", 42 AS "第四十二", 43 AS "第四十三"))) src on ( dest.pure_in_force_date= src.pure_in_force_date ) WHEN MATCHED THEN UPDATE SET dest."第一" = src."第一",dest."第二" = src."第二",dest."第三" = src."第三",dest."第四" = src."第四",dest."第五" = src."第五",dest."第六" = src."第六",dest."第七" = src."第七",dest."第八" = src."第八",dest."第九" = src."第九",dest."第十" = src."第十",dest."第十一" = src."第十一",dest."第十二" = src."第十二",dest."第十三" = src."第十三",dest."第十四" = src."第十四",dest."第十五" = src."第十五",dest."第十六" = src."第十六",dest."第十七" = src."第十七",dest."第十八" = src."第十八",dest."第十九" = src."第十九",dest."第二十" = src."第二十",dest."第二十一" = src."第二十一",dest."第二十二" = src."第二十二",dest."第二十三" = src."第二十三",dest."第二十四" = src."第二十四",dest."第二十五" = src."第二十五",dest."第二十六" = src."第二十六",dest."第二十七" = src."第二十七",dest."第二十八" = src."第二十八",dest."第二十九" = src."第二十九",dest."第三十" = src."第三十",dest."第三十一" = src."第三十一",dest."第三十二" = src."第三十二",dest."第三十三" = src."第三十三",dest."第三十四" = src."第三十四",dest."第三十五" = src."第三十五",dest."第三十六" = src."第三十六",dest."第三十七" = src."第三十七",dest."第三十八" = src."第三十八",dest."第三十九" = src."第三十九",dest."第四十" = src."第四十",dest."第四十一" = src."第四十一",dest."第四十二" = src."第四十二",dest."第四十三" = src."第四十三" WHEN NOT MATCHED THEN INSERT ( pure_in_force_date, "第一","第二","第三","第四","第五","第六","第七","第八","第九","第十","第十一","第十二","第十三","第十四","第十五","第十六","第十七","第十八","第十九","第二十","第二十一","第二十二","第二十三","第二十四","第二十五","第二十六","第二十七","第二十八","第二十九","第三十","第三十一","第三十二","第三十三","第三十四","第三十五","第三十六","第三十七","第三十八","第三十九","第四十","第四十一","第四十二","第四十三" ) VALUES ( src.pure_in_force_date, src."第一",src."第二",src."第三",src."第四",src."第五",src."第六",src."第七",src."第八",src."第九",src."第十",src."第十一",src."第十二",src."第十三",src."第十四",src."第十五",src."第十六",src."第十七",src."第十八",src."第十九",src."第二十",src."第二十一",src."第二十二",src."第二十三",src."第二十四",src."第二十五",src."第二十六",src."第二十七",src."第二十八",src."第二十九",src."第三十",src."第三十一",src."第三十二",src."第三十三",src."第三十四",src."第三十五",src."第三十六",src."第三十七",src."第三十八",src."第三十九",src."第四十",src."第四十一",src."第四十二",src."第四十三" )' ; EXECUTE IMMEDIATE v_sql; END LOOP; end; declare v_1 date := TO_DATE('20250301', 'YYYYMMDD'); v_start date; v_end date := trunc(sysdate); v_current date; v_sql varchar2(32767); begin v_start :=trunc(v_1); for i in 0..(v_end-v_start) loop v_current := v_start+i; v_sql := 'merge into PURE_SPREAD dest using (with t1 as (SELECT a.*,CASE WHEN a.COUNTRY_CODE = ''tz'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ke'' THEN a.IN_FORCE_DATE + 3 / 24 WHEN a.COUNTRY_CODE = ''ci'' THEN a.IN_FORCE_DATE WHEN a.COUNTRY_CODE = ''ph'' THEN a.IN_FORCE_DATE + 8 / 24 END AS NEW_DATE FROM LOAN_BORROW_INFO_TEST a WHERE a.COUNTRY_CODE <> ''gh'' AND a.RISK_SERIAL_NO <> ''googleplay'' AND a.ARCHIVED=1 and a.IN_FORCE_DATE is not null), t2 as (select distinct phone,country_code,NEW_DATE from t1 where TRUNC(NEW_DATE)=TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') and user_type_product=0), t3 as ( select t1.NEW_DATE,t1.ACTUAL_REPAYMENT_AMOUNT,t1.ACTUAL_AMOUNT,t1.state from t2 left join t1 on t2.phone=t1.phone and t2.country_code=t1.country_code and t1.NEW_DATE>=t2.NEW_DATE and t1.new_date is not null), t4 as( select week_num,TO_DATE(''' || TO_CHAR(v_current, 'YYYYMMDD') || ''', ''YYYYMMDD'') as pure_in_force_date,sum(rs-rl)/100 AS Spread from (SELECT case when state !=6 then ACTUAL_REPAYMENT_AMOUNT-ACTUAL_AMOUNT else 0 end as rs, case when state = 6 then ACTUAL_AMOUNT else 0 end as rl, TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7)+1 AS week_num, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 AS week_start, MIN(NEW_DATE) OVER () + TRUNC((NEW_DATE - MIN(NEW_DATE) OVER ()) / 7) * 7 + 6 AS week_end FROM t3 WHERE NEW_DATE BETWEEN TO_DATE("2025-03-01", "YYYY-MM-DD") AND TRUNC(ADD_MONTHS(SYSDATE, 12), "YYYY") - 1) GROUP BY week_num ORDER BY week_num) select * from t4 pivot(sum(round(Spread,6)) for week_num IN (1 AS "第一", 2 AS "第二", 3 AS "第三", 4 AS "第四", 5 AS "第五", 6 AS "第六", 7 AS "第七", 8 AS "第八", 9 AS "第九", 10 AS "第十", 11 AS "第十一", 12 AS "第十二", 13 AS "第十三", 14 AS "第十四", 15 AS "第十五", 16 AS "第十六", 17 AS "第十七", 18 AS "第十八", 19 AS "第十九", 20 AS "第二十", 21 AS "第二十一", 22 AS "第二十二", 23 AS "第二十三", 24 AS "第二十四", 25 AS "第二十五", 26 AS "第二十六", 27 AS "第二十七", 28 AS "第二十八", 29 AS "第二十九", 30 AS "第三十", 31 AS "第三十一", 32 AS "第三十二", 33 AS "第三十三", 34 AS "第三十四", 35 AS "第三十五", 36 AS "第三十六", 37 AS "第三十七", 38 AS "第三十八", 39 AS "第三十九", 40 AS "第四十", 41 AS "第四十一", 42 AS "第四十二", 43 AS "第四十三"))) src on ( dest.pure_in_force_date= src.pure_in_force_date ) WHEN MATCHED THEN UPDATE SET dest."第一" = src."第一",dest."第二" = src."第二",dest."第三" = src."第三",dest."第四" = src."第四",dest."第五" = src."第五",dest."第六" = src."第六",dest."第七" = src."第七",dest."第八" = src."第八",dest."第九" = src."第九",dest."第十" = src."第十",dest."第十一" = src."第十一",dest."第十二" = src."第十二",dest."第十三" = src."第十三",dest."第十四" = src."第十四",dest."第十五" = src."第十五",dest."第十六" = src."第十六",dest."第十七" = src."第十七",dest."第十八" = src."第十八",dest."第十九" = src."第十九",dest."第二十" = src."第二十",dest."第二十一" = src."第二十一",dest."第二十二" = src."第二十二",dest."第二十三" = src."第二十三",dest."第二十四" = src."第二十四",dest."第二十五" = src."第二十五",dest."第二十六" = src."第二十六",dest."第二十七" = src."第二十七",dest."第二十八" = src."第二十八",dest."第二十九" = src."第二十九",dest."第三十" = src."第三十",dest."第三十一" = src."第三十一",dest."第三十二" = src."第三十二",dest."第三十三" = src."第三十三",dest."第三十四" = src."第三十四",dest."第三十五" = src."第三十五",dest."第三十六" = src."第三十六",dest."第三十七" = src."第三十七",dest."第三十八" = src."第三十八",dest."第三十九" = src."第三十九",dest."第四十" = src."第四十",dest."第四十一" = src."第四十一",dest."第四十二" = src."第四十二",dest."第四十三" = src."第四十三" WHEN NOT MATCHED THEN INSERT ( pure_in_force_date, "第一","第二","第三","第四","第五","第六","第七","第八","第九","第十","第十一","第十二","第十三","第十四","第十五","第十六","第十七","第十八","第十九","第二十","第二十一","第二十二","第二十三","第二十四","第二十五","第二十六","第二十七","第二十八","第二十九","第三十","第三十一","第三十二","第三十三","第三十四","第三十五","第三十六","第三十七","第三十八","第三十九","第四十","第四十一","第四十二","第四十三" ) VALUES ( src.pure_in_force_date, src."第一",src."第二",src."第三",src."第四",src."第五",src."第六",src."第七",src."第八",src."第九",src."第十",src."第十一",src."第十二",src."第十三",src."第十四",src."第十五",src."第十六",src."第十七",src."第十八",src."第十九",src."第二十",src."第二十一",src."第二十二",src."第二十三",src."第二十四",src."第二十五",src."第二十六",src."第二十七",src."第二十八",src."第二十九",src."第三十",src."第三十一",src."第三十二",src."第三十三",src."第三十四",src."第三十五",src."第三十六",src."第三十七",src."第三十八",src."第三十九",src."第四十",src."第四十一",src."第四十二",src."第四十三" )' ; EXECUTE IMMEDIATE v_sql; END LOOP; end; [42000][904] ORA-00904: "YYYY": 标识符无效 ORA-06512: 在 line 67
最新发布
06-07
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值