Updating pl sql trigger
There are lot of opportunities from many reputed companies in the world.
“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.