Oracle Notes

From Moo
Jump to: navigation, 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[edit]

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

windows start up[edit]

Starting and stopping oracle on windows

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