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;
- 2 Answers
- 3675 Views
- I also Faced
- E-Mail Answers
Answer Posted / eshwer
Run this query and check the result you can easyly understand y we used trim function..
select length(to_char(sysdate,'day')), length(rtrim(to_char(sysdate,'day'))) from dual;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does (+) mean in sql joins?
How to fix oracle error ora-00942: table or view does not exist
What are the basic sql commands?
How do you take the union of two tables in sql?
What does trigger mean in psychology?
What is inner join in sql?
Which are the different character-manipulation functions in sql?
What is raid? How does it help storage of databases?
what is auto increment? : Sql dba
What is foreign key and example?
What is cross join example?
Why indexing is needed?
How can we find duplicate records in a table?
What is forward declaration in pl sql?
What is partition in sql query?
