what does the t-sql command ident_incr does? : Transact sql
No Answer is Posted For this Question
Be the First to Post Answer
How to start the command-line sql*plus?
How to handle bulk data?
how to write date and time literals? : Sql dba
How can a function retun more than one value in oracle with proper example?
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 is indexing done in search engines?
what is the difference between union and union all
14 Answers IBM, Luxoft, Oracle,
What is cost in sql execution plan?
What is compilation error in pl sql?
Can I create table without primary key?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
How do u count no of rows in a table?