question

Rakesh_kp123 avatar image
Rakesh_kp123 asked

new column to be created for a table and data to datetime format to be updated

there is a table UC_OFCOM_HIST_LOG THIS HAS a column FILE_NAME and data in this column is like c003030303_EM_ABINTR_ 20210809125249 IN THIS FORMAT now using this query I have segregated date time format, now I want to create a new column by name LOAD_DATE_TIME ON THE SAME TABLE UC_OFCOM_HIST_LOG and make this data appear in that column how this can be done whatsapp-image-2022-09-08-at-35333-pm.jpeg

oracle
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.