Updating pl sql trigger

Rated 4.17/5 based on 866 customer reviews

It contains one column Dummy and one row with the value X.The Dual Table is useful when you want to return a value only once.Alias is a user-defined alternative name given to the column or table.By default column alias headings appear in upper case.Date Functions are MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, LAST_DAY, ROUND, TRUNC.Dual table is owned by the user SYS and can be accessed by all users.Enclose the alias in a double quotation marks (“ “) to make it case sensitive.

’is a’

Leave a Reply