![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Sql
arlendai
这个作者很懒,什么都没留下…
展开
-
What are the difference between DDL, DML and DCL commands?
DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: CREATE - to create objects in the database ALTER - alters the structure of...原创 2012-03-02 16:02:23 · 119 阅读 · 0 评论 -
oracle trunc to_char
select to_char(sysdate,'yyyy') from dual; --年 select to_char(sysdate,'Q' from dual; --季 select to_char(sysdate,'mm') from dual; --月 select to_char(sysdate,'dd') from dual; --日 ddd 年中的第几天 WW 年中的第几...原创 2012-03-05 16:31:43 · 88 阅读 · 0 评论