Oracle: To see the entire date field
TO_CHAR(datecol, 'DD-MON-YYYY HH:MI:SS')
update
odsadmin.ods_uv_co
set
opening_physical = to_date('01-JAN-1990','DD-MON-YYYY')
where
store_srcnum in (9099,0000,0001,0002,0047,0995,0104,0927)
/
Postgres: To list table owners
SELECT schemaname, tablename, tableowner FROM pg_tables WHERE schemaname NOT IN ('pg_catalog', 'information_schema') ORDER BY tableowner, schemaname, tablename;
Comments
Post a Comment