You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for SYSDATE


1 to 20 of 351 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

SYSDATE

SYSDATESyntax sysdate::= Description of the illustration sysdate.gif Purpose SYSDATE returns the current … system date and time: SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW" FROM DUAL; NOW ------------------- 04-13-2001 09:45:51

DML Reference, 10g Release 1 (10.1)

SYSDATE

SYSDATEThe SYSDATE function returns the current date and time. The format of the date is controlled by the … Value DATETIME Syntax SYSDATE Examples Example 23-5 Displaying the Current Date The following … statement: SHOW SYSDATE displays the current date: 08-Sep-00

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.and correct the error in hash expression. ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expre\ssion.Cause: TO_DATE, USERENV and SYSDATE are not allowed in hash expressions. Action: Recreate the … cluster and correct the error in hash expression. ORA-02471: SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expre\ssion.

Packages and Types Reference, 10g Release 1 (10.1)

137 OWA_UTIL

SyntaxOWA_UTIL.CHOOSE_DATE( p_name IN VARCHAR2, p_date IN DATE DEFAULT SYSDATE);

Packages and Types Reference, 10g Release 1 (10.1)

41 DBMS_JOB

ExampleBEGIN DBMS_JOB.CHANGE(14144, , , 'sysdate+3'); COMMIT; END;

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_OFFLINE Function

SyntaxVARCHAR2, runtime_parm_id IN NUMBER:= -1e-130, next_date IN DATE:= SYSDATE, interval IN VARCHAR2 … := 'SYSDATE + 1', use_default_gowner IN BOOLEAN:= true) return NUMBER;

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_ONLINE Function

SyntaxVARCHAR2, runtime_parm_id IN NUMBER:= -1e-130, next_date IN DATE:= SYSDATE, interval IN VARCHAR2 … := 'SYSDATE + 1', use_default_gowner IN BOOLEAN:= true) return NUMBER;

Packages and Types Reference, 10g Release 1 (10.1)

41 DBMS_JOB

SyntaxDBMS_JOB.BROKEN ( job IN BINARY_INTEGER, broken IN BOOLEAN, next_date IN DATE DEFAULT SYSDATE);

Packages and Types Reference, 10g Release 1 (10.1)

64 DBMS_PROFILER

SyntaxDBMS_PROFILER.START_PROFILER( run_comment IN VARCHAR2:= sysdate, run_comment1 IN VARCHAR2 … VARCHAR2:= sysdate, run_comment1 IN VARCHAR2:='') RETURN BINARY_INTEGER; DBMS_PROFILER.START_PROFILER … ( run_comment IN VARCHAR2:= sysdate, run_comment1 IN VARCHAR2:='', run_number OUT BINARY_INTEGER … ); DBMS_PROFILER.START_PROFILER(

Administrator's Guide, 10g Release 1 (10.1)

25 Moving from DBMS_JOB to DBMS_SCHEDULER

Creating a Job'', NULL, SYSDATE, ''AD_PRES'', NULL, NULL, NULL, NULL);', SYSDATE, 'SYSDATE+1'); COMMIT; END; / An … '', ''DOGAN'', ''sally.dogan@xyzcorp.com'', NULL, SYSDATE,''AD_PRES'', NULL, NULL, NULL, NULL … );'); start_date => SYSDATE, repeat_interval => 'FREQ = DAILY; INTERVAL = 1'); END; /

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_OFFLINE Function

Syntax, user_name IN VARCHAR2:= NULL, runtime_parm_id IN NUMBER:= -1e-130, next_date IN DATE:= SYSDATE … , interval IN VARCHAR2:= 'SYSDATE + 1', use_default_gowner IN BOOLEAN:= true) RETURN NUMBER;

Advanced Replication Management API Reference, 10g Release 1 (10.1)

INSTANTIATE_ONLINE Function

Syntax:= NULL, user_name IN VARCHAR2:= NULL, runtime_parm_id IN NUMBER:= -1e-130, next_date IN DATE:= SYSDATE … , interval IN VARCHAR2:= 'SYSDATE + 1', use_default_gowner IN BOOLEAN:= true) RETURN NUMBER;

Advanced Replication Management API Reference, 10g Release 1 (10.1)

CREATE_REFRESH_TEMPLATE Function

Syntax:= NULL, last_modified IN DATE:= SYSDATE, modified_by IN VARCHAR2:= USER, creation_date IN DATE:= SYSDATE, created_by IN VARCHAR2:= USER) return NUMBER;

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on Check Constraints You cannot specify a check constraint for a view. However, you can…SCOPE REF Constraints In a table with a REF column, each REF value in the column can conceivably reference a row in a different object table. The SCOPE clause restricts the scope of references to a single table, scope_table. The values in the REF column or attribute point to objects in scope_table, in which object instances of the same type as the REF column are stored. Specify the SCOPE clause to

Packages and Types Reference, 10g Release 1 (10.1)

93 DBMS_STATS

Gathering Daytime System Statistics(''mystats'',''OLTP'');' sysdate, 'sysdate + 1'); COMMIT; END; BEGIN DBMS_JOB.SUBMIT (:jobno … , 'DBMS_STATS.IMPORT_SYSTEM_STATS (''mystats'',''OLAP'');' sysdate + 0.5, 'sysdate + 1'); COMMIT; END;

Reference, 10g Release 1 (10.1)

ORDSource Methods

current_timeThe update time. Usage Notes If current_time is NULL, updateTime is set to SYSDATE (the current time). Pragmas None. Exceptions None. Examples None.

Packages and Types Reference, 10g Release 1 (10.1)

12 DBMS_ADVISOR

Examples', 'ROLLUP', 100,400,5041,103,640445,680000,2, 1,SYSDATE,1,'SH','SELECT avg(amount_sold) FROM sh.sales'); END; /

Packages and Types Reference, 10g Release 1 (10.1)

12 DBMS_ADVISOR

Examples(workload_name, 'MONTHLY', 'ROLLUP', 100,400,5041,103,640445,680000,2, 1,SYSDATE,1,'SH','SELECT avg … ', 100,400,5041,103,640445,680000,2, 1,SYSDATE,1,'SH','SELECT avg(amount_sold) FROM sh.sales

DML Reference, 10g Release 1 (10.1)

LAST_DAY

datetime-expressionthe month. SHOW JOINCHARS('Days left: ' LAST_DAY(SYSDATE) - SYSDATE) When today's date is September