what is the use of friend function? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
how many sql ddl commands are supported by 'mysql'? : Sql dba
Where the sql database files are stored?
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;
what are integrity rules?
Why do we use %rowtype & %type in plsql?
How does sql store data?
What is #table in sql?
What are different types of statements supported by sql?
How do sql triggers work?
How does sql profiler work?
What is trigger in sql? Explain
Are pl sql variables case sensitive?