字符与table里的column相结合使用来OUTPUT数据

最新推荐文章于 2024-01-31 01:27:14 发布

benson_xi

最新推荐文章于 2024-01-31 01:27:14 发布

阅读量459

点赞数

分类专栏： ORACLE学习积累文章标签： output table insert

本文链接：https://blog.csdn.net/benson_xi/article/details/6933757

版权

ORACLE学习积累专栏收录该内容

16 篇文章 0 订阅

订阅专栏

通过一张表里的数值作为输出数值表现在一个栏位里，例如将输出信息为"Dear Customer customer_name"在栏位中显示出来，定义客户名称数据值来之于CUSTOMERS这张表里的CUSTOMER_NAME 这个栏位。(produce output that states "Dear Customer customer_name, ". The customer_name datavalues come from the CUSTOMER_NAME column in the CUSTOMERS table.)CREATE TABLE CUSTOMERS(CUSTOMER_ID NUMBER(4) NOT NULLCUSTOMER_NAME VARCHAR2(100) NOT NULLCUSTOMER_ADDRESS VARCHAR2(150)CUSTOMER_PHONE VARCHAR2(20))INSERT INTO CUSTOMERS VALUES('1','TOM','BEIJING','12345678912');INSERT INTO CUSTOMERS VALUES('2','JAM','BEIJING','12344584233');INSERT INTO CUSTOMERS VALUES('3','JON','SHANGHAI','12344587754');执行过程：SELECT 'Dear Customer ' || customer_name || ',' FROM customers WHERE customer_id=1;显示结果：Dear coutomer TOM,