Oracle Notes

From sheep

Revision as of 21:42, 14 September 2021 by Martin (talk | contribs) (Created page with " select * from dba_objects where object_name='UPPER_CASE_NAME'; note the object names are always upper case - object_type contains function/procedure etc. == date formatting...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

select * from dba_objects where object_name='UPPER_CASE_NAME';

note the object names are always upper case - object_type contains function/procedure etc.

date formatting

alter session set nls_date_format = 'DD/MM/YYYY HH24:MI:SS';

windows start up

Starting and stopping oracle on windows

oradim -shutdown -sid SID -shuttype srvc,inst -shutmode immediate

oradim -startup -sid SID -starttype srvc,inst

Retrieved from ‘https://luminoussheep.net/mediawiki/index.php?title=Oracle_Notes&oldid=90’