What does truncate mean in sql?
No Answer is Posted For this Question
Be the First to Post Answer
How can I get the number of records affected by a stored procedure?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is data types in sql?
Can sql developer connect to db2?
How many scalar data types are supported in pl/sql?
How to sort the rows in sql.
What does 0 mean in sql?
What does fetching a cursor do?
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 is primary key secondary key alternate key candidate key?
how to shut down the server with 'mysqladmin'? : Sql dba
Types of joins ?
3 Answers Digital GlobalSoft, HeadStrong,