when sysdate is not as system date

Dear my audience
there is a problem of difference of sysdate than system date or that sysdate show wrong date and here after search and test and try i find the solution are

SQL> alter system set fixed_date = none

  2  /

 

System altered.

 

SQL> select sysdate

  2    from dual

  3  /

 

SYSDATE

-------------------

15-11-2017 10:53:40

 

 

best regards

Yasser

Oracle Reserved Words

List of Oracle Reserved Words

Oracle Reserved Words and Keywords
ACCESS	ACCOUNT	ACTIVATE
ADD	ADMIN	ADVISE
AFTER	ALL	ALL_ROWS
ALLOCATE	ALTER	ANALYZE
AND	ANY	ARCHIVE
ARCHIVELOG	ARRAY	AS
ASC	AT	AUDIT
AUTHENTICATED	AUTHORIZATION	AUTOEXTEND
AUTOMATIC	BACKUP	BECOME
BEFORE	BEGIN	BETWEEN
BFILE	BITMAP	BLOB
BLOCK	BODY	BY
CACHE	CACHE_INSTANCES	CANCEL
CASCADE	CAST	CFILE
CHAINED	CHANGE	CHAR
CHAR_CS	CHARACTER	CHECK
CHECKPOINT	CHOOSE	CHUNK
CLEAR	CLOB	CLONE
CLOSE	CLOSE_CACHED_OPEN_CURSORS	CLUSTER
COALESCE	COLUMN	COLUMNS
COMMENT	COMMIT	COMMITTED
COMPATIBILITY	COMPILE	COMPLETE
COMPOSITE_LIMIT	COMPRESS	COMPUTE
CONNECT	CONNECT_TIME	CONSTRAINT
CONSTRAINTS	CONTENTS	CONTINUE
CONTROLFILE	CONVERT	COST
CPU_PER_CALL	CPU_PER_SESSION	CREATE
CURRENT	CURRENT_SCHEMA	CURREN_USER
CURSOR	CYCLE
DANGLING	DATABASE	DATAFILE
DATAFILES	DATAOBJNO	DATE
DBA	DBHIGH	DBLOW
DBMAC	DEALLOCATE	DEBUG
DEC	DECIMAL	DECLARE
DEFAULT	DEFERRABLE	DEFERRED
DEGREE	DELETE	DEREF
DESC	DIRECTORY	DISABLE
DISCONNECT	DISMOUNT	DISTINCT
DISTRIBUTED	DML	DOUBLE
DROP	DUMP	EACH
ELSE	ENABLE	END
ENFORCE	ENTRY	ESCAPE
EXCEPT	EXCEPTIONS	EXCHANGE
EXCLUDING	EXCLUSIVE	EXECUTE
EXISTS	EXPIRE	EXPLAIN
EXTENT	EXTENTS	EXTERNALLY
FAILED_LOGIN_ATTEMPTS	FALSE	FAST
FILE	FIRST_ROWS	FLAGGER
FLOAT	FLOB	FLUSH
FOR	FORCE	FOREIGN
FREELIST	FREELISTS	FROM
FULL	FUNCTION	GLOBAL
GLOBALLY	GLOBAL_NAME	GRANT
GROUP	GROUPS	HASH
HASHKEYS	HAVING	HEADER
HEAP	IDENTIFIED	IDGENERATORS
IDLE_TIME	IF	IMMEDIATE
IN	INCLUDING	INCREMENT
INDEX	INDEXED	INDEXES
INDICATOR	IND_PARTITION	INITIAL
INITIALLY	INITRANS	INSERT
INSTANCE	INSTANCES	INSTEAD
INT	INTEGER	INTERMEDIATE
INTERSECT	INTO	IS
ISOLATION	ISOLATION_LEVEL	KEEP
KEY	KILL	LABEL
LAYER	LESS	LEVEL
LIBRARY	LIKE	LIMIT
LINK	LIST	LOB
LOCAL	LOCK	LOCKED
LOG	LOGFILE	LOGGING
LOGICAL_READS_PER_CALL	LOGICAL_READS_PER_SESSION	LONG
MANAGE	MASTER	MAX
MAXARCHLOGS	MAXDATAFILES	MAXEXTENTS
MAXINSTANCES	MAXLOGFILES	MAXLOGHISTORY
MAXLOGMEMBERS	MAXSIZE	MAXTRANS
MAXVALUE	MIN	MEMBER
MINIMUM	MINEXTENTS	MINUS
MINVALUE	MLSLABEL	MLS_LABEL_FORMAT
MODE	MODIFY	MOUNT
MOVE	MTS_DISPATCHERS	MULTISET
NATIONAL	NCHAR	NCHAR_CS
NCLOB	NEEDED	NESTED
NETWORK	NEW	NEXT
NOARCHIVELOG	NOAUDIT	NOCACHE
NOCOMPRESS	NOCYCLE	NOFORCE
NOLOGGING	NOMAXVALUE	NOMINVALUE
NONE	NOORDER	NOOVERRIDE
NOPARALLEL	NOPARALLEL	NOREVERSE
NORMAL	NOSORT	NOT
NOTHING	NOWAIT	NULL
NUMBER	NUMERIC	NVARCHAR2
OBJECT	OBJNO	OBJNO_REUSE
OF	OFF	OFFLINE
OID	OIDINDEX	OLD
ON	ONLINE	ONLY
OPCODE	OPEN	OPTIMAL
OPTIMIZER_GOAL	OPTION	OR
ORDER	ORGANIZATION	OSLABEL
OVERFLOW	OWN	PACKAGE
PARALLEL	PARTITION	PASSWORD
PASSWORD_GRACE_TIME	PASSWORD_LIFE_TIME	PASSWORD_LOCK_TIME
PASSWORD_REUSE_MAX	PASSWORD_REUSE_TIME	PASSWORD_VERIFY_FUNCTION
PCTFREE	PCTINCREASE	PCTTHRESHOLD
PCTUSED	PCTVERSION	PERCENT
PERMANENT	PLAN	PLSQL_DEBUG
POST_TRANSACTION	PRECISION	PRESERVE
PRIMARY	PRIOR	PRIVATE
PRIVATE_SGA	PRIVILEGE	PRIVILEGES
PROCEDURE	PROFILE	PUBLIC
PURGE	QUEUE	QUOTA
RANGE	RAW	RBA
READ	READUP	REAL
REBUILD	RECOVER	RECOVERABLE
RECOVERY	REF	REFERENCES
REFERENCING	REFRESH	RENAME
REPLACE	RESET	RESETLOGS
RESIZE	RESOURCE	RESTRICTED
RETURN	RETURNING	REUSE
REVERSE	REVOKE	ROLE
ROLES	ROLLBACK	ROW
ROWID	ROWNUM	ROWS
RULE	SAMPLE	SAVEPOINT
SB4	SCAN_INSTANCES	SCHEMA
SCN	SCOPE	SD_ALL
SD_INHIBIT	SD_SHOW	SEGMENT
SEG_BLOCK	SEG_FILE	SELECT
SEQUENCE	SERIALIZABLE	SESSION
SESSION_CACHED_CURSORS	SESSIONS_PER_USER	SET
SHARE	SHARED	SHARED_POOL
SHRINK	SIZE	SKIP
SKIP_UNUSABLE_INDEXES	SMALLINT	SNAPSHOT
SOME	SORT	SPECIFICATION
SPLIT	SQL_TRACE	STANDBY
START	STATEMENT_ID	STATISTICS
STOP	STORAGE	STORE
STRUCTURE	SUCCESSFUL	SWITCH
SYS_OP_ENFORCE_NOT_NULL$	SYS_OP_NTCIMG$	SYNONYM
SYSDATE	SYSDBA	SYSOPER
SYSTEM	TABLE	TABLES
TABLESPACE	TABLESPACE_NO	TABNO
TEMPORARY	THAN	THE
THEN	THREAD	TIMESTAMP
TIME	TO	TOPLEVEL
TRACE	TRACING	TRANSACTION
TRANSITIONAL	TRIGGER	TRIGGERS
TRUE	TRUNCATE	TX
TYPE	UB2	UBA
UID	UNARCHIVED	UNDO
UNION	UNIQUE	UNLIMITED
UNLOCK	UNRECOVERABLE	UNTIL
UNUSABLE	UNUSED	UPDATABLE
UPDATE	USAGE	USE
USER	USING	VALIDATE
VALIDATION	VALUE	VALUES
VARCHAR	VARCHAR2	VARYING
VIEW	WHEN	WHENEVER
WHERE	WITH	WITHOUT
WORK	WRITE	WRITEDOWN
WRITEUP	XID	YEAR
ZONE