Explian rowid, rownum? What are the psoducolumns we have?
No Answer is Posted For this Question
Be the First to Post Answer
How do you sort in sql?
how to enter binary numbers in sql statements? : Sql dba
How do we accept inputs from user during runtime?
What is a sql*loader control file?
How to run sql functions in pl/sql?
How can I get the number of records affected by a stored procedure?
Which normal form is best?
what are date and time functions in mysql? : Sql dba
what is the difference between pragma exception_init and raise_application_error
1 Answers Aetins, State Street,
How many triggers can be implemented for a table?
What is not null 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;