Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4306 Views
- I also Faced
- E-Mail Answers
Answer Posted / eshwer
Hi,
see the below example you can easily understand that why we are using trim.
select decode(TRIM(to_char(SYSDATE,'Day')),'Monday','3','1') from dual
1. select decode(to_char(SYSDATE,'Day'),'Monday','3','1') from dual
Ans : 1 – error because eroju Monday ne kabatti query 3 return cheyali kani 1 return chesthundi. Karanam spaces so we need to use trim function.enduko kinda points chudu
2. Run this query and check the output select to_char(SYSDATE,'Day') from dual
3. select length(to_char(SYSDATE,'Day')) from dual –- ee query run chei output 9 vasthundi. But Monday actual length is 6.
run these queries
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is pivot in sql?
What are types of exception?
How do I view output in sql developer?
What are the advantages of pl sql?
Why is %isopen always false for an implicit cursor?
Which function is used to return remainder in a division operator in sql?
What is column?
how to shutdown mysql server? : Sql dba
what happens if you no create privilege in a database? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How much ram can sql express use?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
How is pl sql different from sql?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
