about oracle functions !

JasLi 2003-02-27 01:32:59

I need more info about oracle functions' description document !
could you provide some ?

...全文

94 2 打赏收藏转发到动态举报

写回复

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

JasLi 2003-02-28

打赏
举报

回复

thank you ! Xiao Beck !

beckhambobo 2003-02-27

打赏
举报

回复

看书吧，

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/function.htm#998166

Oracle Functions(Fun_Get_Timekey): 1.FUN_GET_HOUR_TIMEKEY CREATE OR REPLACE FUNCTION FUN_GET_HOUR_TIMEKEY(DATED DATE) RETURN DATE AS V_TIMEKEY DATE; BEGIN IF DATED IS NULL THEN RETURN TO_DATE('...

开发过程中经常会有产生随机数的需求，而oracle本身自带的有这样的功能，下面介绍一下拥有此功能的包DBMS_RANDOM，主要以官方文档来说明： The DBMS_RANDOM package provides a built-in random number generator. 该包里包含了几个子程序，这里仅仅介绍两个： RANDOM function This

4.Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds B. S

QUESTION 36 Choose three Which three statements are true about sequences in a single instance Oracle database? A) A sequence’s unallocated cached values are lost if the instance shuts down. B) Two or ...

274. Given below is a list of functions and their purpose in random order. Function Purpose 1)NVL a) Used for evaluating NOT NULL and NULL values 2)NULLIF b) Used to return the first nonnull alues

基础和管理

17,377

社区成员

95,112

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章