Hi, see the below example you can easily understand that why we are usin

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;

Question Posted / eshwer

2 Answers
4289 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

Please Help Members By Posting Answers For Below Questions

How does postgresql compare to oracle/db2/ms sql server/informix?

1018

what is the difference between primary key and unique key? : Sql dba

1016

What are the different set operators available in sql?

1009

What is the difference between function and procedure in pl/sql?

1058

What is trigger in pl sql?

980

when is the use of update_statistics command? : Sql dba

1027

What is the primary key?

934

What are the types of views in sql?

1082

Where is sql database stored?

961

What is sql and how does it work?

1150

Can you have more than one trigger on a table?

986

Which tcp/ip port does sql server run?

990

What happens when a trigger is associated to a view?

897

What is gpt format?

929

What are types of joins?

949