how to check myisam tables for errors? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
How do I filter in sql profiler?
what is the difference between cluster and non cluster index? : Sql dba
how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.
How many developers work on postgresql?
How to recompile a already made trigger?
How do I create a memory optimized filegroup?
How many triggers can be implemented for a table?
Is nosql relational?
How do you delete data from a table?
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;
differentiate between float and double. : Sql dba
Types of optimization?