Updating pl sql trigger

Rated 4.94/5 based on 675 customer reviews

There are lot of opportunities from many reputed companies in the world.

updating pl sql trigger-89

updating pl sql trigger-77

updating pl sql trigger-23

updating pl sql trigger-28

“AS” Keyword before the alias name makes the SELECT clause easier to read.

COUNT (DISTINCT EXP): Returns the number of unique, non-null values in the column identified by expression.

Ans: A sub query is a SELECT statement that is embedded in a clause of another SELECT statement.

TO_CHAR Function use fm element to remove padded blanks or suppress leading zeros.

TO_CHAR Function formats: TO_CHAR (date, ‘format_model’). Format model must be enclosed in single quotation marks and is case sensitive.

Leave a Reply