【文件属性】:
文件名称:使用字符串处理函数-oracle基础讲义
文件大小:4.17MB
文件格式:PPT
更新时间:2021-04-22 13:29:19
orcle基础讲义
使用字符串处理函数
SELECT employee_id, CONCAT(first_name, last_name) NAME,
job_id, LENGTH (last_name),
INSTR(last_name, 'a') "Contains 'a'?"
FROM employees
WHERE SUBSTR(job_id, 4) = 'REP';
1
2
3
1
2
3
以r结束的姓氏的员工的数据
SELECT employee_id, CONCAT(first_name, last_name) NAME,
LENGTH (last_name), INSTR(last_name, 'a') "Contains 'a'?"
FROM employees
WHERE SUBSTR(last_name, -1, 1) = ‘r';
*