Are subqueries faster than joins?
No Answer is Posted For this Question
Be the First to Post Answer
What is latest version of sql?
Is sql scripting language?
how to delete an existing column in a table? : Sql dba
List the different type of joins?
What are the most important ddl statements in sql?
what is purge command explain about oracle performance tuning
2 Answers Accenture, eCentric Solutions,
what is innodb? : Sql dba
What is nvl?
What is a unique constraint?
What is scalar function in sql?
how to findout the 100th maximum salary
Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;