【文件属性】:
文件名称:To-char举例-Oracle数据库Sql语句详解大全 PPT
文件大小:3.47MB
文件格式:PPT
更新时间:2021-04-25 22:11:17
详解大全
To-char举例
SQL> SELECT last_name, TO_CHAR(start_date,
2 'fmDdspth "of " Month YYYY fmHH:MI:SS AM') HIREDATE
3 FROM s_emp
4 WHERE start_date LIKE '%91';
SQL> SELECT 'Order ‘ || TO_CHAR(id) ||
2 ' was filled for a total of ‘ || TO_CHAR(total,'fm$9,999,999')
3 FROM s_ord
4 WHERE ship_date = '21-SEP-92';