Which one is better sql or oracle?
No Answer is Posted For this Question
Be the First to Post Answer
what is sql.
Are sql database names case sensitive?
What is Highwatermark?
What are the differences between in and exists clause?
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;
How to find only %th Highest Sal
Can we join 3 tables in sql?
Is sql a oracle?
What are the types pl/sql code blocks?
What are different joins used in sql?
what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?
What is an oracle stored procedure?