Where is sql database stored?
No Answer is Posted For this Question
Be the First to Post Answer
display your age in months?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What is bind reference and how can it be created?
What is mutating table error?
What is data modelling in sql?
How many aggregate functions are available there in sql?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
what is the difference between implicit and explicit trigger
What is primary and foreign key?
How do I audit the sql sent to the server?
How delete a row in sql?
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;