update แบบมีเงื่อนไข

update MY_TABLE
                            set STARTED_PROCESS_DATE = (
                                    CASE
                                    WHEN (STARTED_PROCESS_DATE is null)
                                        THEN systimestamp
                                    ELSE
                                        STARTED_PROCESS_DATE
                                    END )
                               where id = ‘xxx’

น่าจะหาตั้งนาน เผลอใช้แบบเปลืองๆมาตั้งนาน 555555

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s