首页
学习
活动
专区
工具
TVP
发布
精选内容/技术社群/优惠产品,尽在小程序
立即前往
  • 您找到你想要的搜索结果了吗?
    是的
    没有找到

    PL/SQL学习笔记-条件控制

    这段程序用到了if…then  else  end if结构 1.其中length()函数可以获取一个字符串的字符长度 另外还有lengthb()函数,可以获取一个字符串的字节长度 2.substr()函数,可以按字符长度获取一个字符串的子字符串, 另外还有substrb()函数,可以按字节长度获取一个字符串的子字符串 3.select… 句是从一个表里获取一条数据,并把数据存储在我们定义的变量中 注意一定要是一条数据,因为我们的变量不是table或者record类型 至于这些类型会在后面的文章中提到 另外还有if…then   elseif…then   else   end if结构 这里就不举例子了 注意elseif是连在一起写的,这很像vb的语法,与C#语法有区别 二:case条件控制 先看例子:

    01

    Install Jumpserver42

    Copying '/opt/jumpserver/apps/static/js/plugins/inputTags.jquery.min.js' Copying '/opt/jumpserver/apps/static/js/plugins/cropper/cropper.min.js' Copying '/opt/jumpserver/apps/static/js/plugins/datatables/datatables.min.js' Copying '/opt/jumpserver/apps/static/js/plugins/datatables/pdfmake.min.js.map' Copying '/opt/jumpserver/apps/static/js/plugins/datatables/i18n/English.lang' Copying '/opt/jumpserver/apps/static/js/plugins/datatables/i18n/zh-hans.json' Copying '/opt/jumpserver/apps/static/js/plugins/datepicker/bootstrap-datepicker.js' Copying '/opt/jumpserver/apps/static/js/plugins/demo/peity-demo.js' Copying '/opt/jumpserver/apps/static/js/plugins/dropzone/dropzone.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/echarts-all.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/echarts.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/bar.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/chord.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/eventRiver.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/force.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/funnel.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/gauge.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/heatmap.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/k.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/line.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/map.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/pie.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/radar.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/scatter.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/tree.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/treemap.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/venn.js' Copying '/opt/jumpserver/apps/static/js/plugins/echarts/chart/wordCloud.js' C

    02

    Install Jumpserver43

    Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/modules/heatmap.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/modules/heatmap.src.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/modules/no-data-to-display.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/modules/no-data-to-display.src.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/modules/solid-gauge.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/modules/solid-gauge.src.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/themes/dark-blue.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/themes/dark-green.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/themes/dark-unica.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/themes/gray.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/themes/grid-light.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/themes/grid.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/themes/sand-signika.js' Copying '/opt/jumpserver/apps/static/js/plugins/highcharts/themes/skies.js' Copying '/opt/jumpserver/apps/static/js/plugins/iCheck/icheck.min.js' Copying '/opt/jumpserver/apps/static/js/plugins/jstree/jstree.min.js' Copying '/opt/jumpserver/apps/static/js/plugins/layer/layer.js' Copying '/opt/jumpserver/apps/static/js/plugins/layer/skin/layer.css' Copying '/opt/jumpserver/apps/static/js/plugins/layer/skin/default/icon-ext.png' Copying '/opt/jumpserver/apps/static/js/plugins/layer/skin/default/icon.png' Copying '/opt/jumpserver/apps/static/js/plugins/layer/skin/default/loading-0.gif' Copying '/opt/jumpserver/apps/static/js/plugins/layer/skin/default/loading-1.gif' Copying '/opt/jumpserver/apps/static/js/plugins/layer/skin/default/loading-2.gif' Copying '/opt/jumpserver/apps/static/js/plugins/magnific/jquery.magnific-popup.min.js' Copying '/opt/jumpserver/apps/static/js/plugins/metisMenu/jquery.metisMenu.js' Copying '/opt/jumpserver/apps/static/js/plugins/pace/pac

    01

    扫码

    添加站长 进交流群

    领取专属 10元无门槛券

    手把手带您无忧上云

    扫码加入开发者社群

    相关资讯

    热门标签

    活动推荐

      运营活动

      活动名称
      广告关闭
      领券