Oracle Notes: Difference between revisions
Jump to navigation
Jump to search
(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...") |
(No difference)
|
Latest revision as of 21:42, 14 September 2021
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