1、首先我们启动plsql并登陆oracle数据库。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0bd162d9f2d3572c1e67a33b8413632763d0c34b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、然后我们根据图示代码创建测试表。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ae51f3deb48f8c54ef73fac834292df5e1fe7fb0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后我们根据图示代码插入测试数据,除了F8执行SQL之外,还需要点击【提交】按钮才能将数据插入到数据库。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e61190ef76c6a7efba9d97c1f3faaf51f2de6699?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、desc 作为降序排序的关键字,按照COLCODE 列降序展示表数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b21c8701a18b87d6daf994f8090828381e30fd9a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、【DESC + 表名】:显示表的详细字段(直接在Plsql的sql窗口中执行会报错)。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a044ad345982b2b7872506233fadcbef77099b9a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、然后我们根据图示代码点击plsql的【新建】图标,选择【command window】。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9f510fb30f2442a709b4c242df43ad4bd013029a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、然后我们根据图示代码在【command window】中输入 DESC TESTTABLE 并回车,即可看到TESTTABLE 表的字段信息。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/2f738bd4b31c87015a508d01297f9e2f0608ff77?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)