What is meant by Materialized view?
Answers were Sorted based on User's Feedback
Answer / raj&
materialized views are schema objects that can be used to summarize,precompute,replicate and distribute data.
Is This Answer Correct ? | 4 Yes | 1 No |
How do I create a sql script?
What is difference between select statement and cursor
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)
write a qurey for finding the length of the sting.
Which language is used in sql?
Explain ttitle and btitle.
Where is pl sql used?
I have a CURSOR then why we need BULK COLLECT again?
Is progress software supports to ( pl/sql )?
Is foreign key mandatory?
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;