What is the difference between an inner and outer join?
No Answer is Posted For this Question
Be the First to Post Answer
What is an alias command?
What is relationship? How many types of relationship are there?
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 insert the data through views? The view is depending upon more than two tables? how to update materalized views?
Can we call a function containing dml statements in a select query?
What is the use of function in sql?
Can primary key be changed?
Can a composite key be null?
Why sql query is slow?
difference between anonymous blocks and sub-programs.
What programs use sql?
How can u find column name from a table which have max value in a row.( not max value)