What is the current version of sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between having clause and where clause?
What is a temporal data type?
Is crud a cuss word?
Why we use triggers in mysql?
How to call DDL statements from pl/sql?
Is sql developer case sensitive?
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 the ddl commands?
What is a pdo connection?
I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
How we can update the view?
Can unique keys be null?