| 1015 | 1/29/2017 4:26:55 PM | 0006013149 | |||||||||
| 1015 | 1/29/2017 4:39:02 PM | 0006013149 | |||||||||
| 1017 | 1/29/2017 9:56:31 AM | 0002566302 | |||||||||
| 1017 | 1/29/2017 10:28:42 AM | 0002566302 | |||||||||
| update at_proc_mast a set in_time = (select min(TO_CHAR(To_Date(IN_TIME,'HH24:MI:SS'),'HH24MISS')) from access_log b a.emp_id=b.emp_id and b.at_dt=a.at_dt ) where at_dt='29-jan-17' | |||||||||||
Thursday, February 23, 2017
id & date wise update
Subscribe to:
Post Comments (Atom)
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ... -
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...
No comments:
Post a Comment