Answers were Sorted based on User's Feedback
Answer / debasish sinha
create or replace trigger trg_sun
before insert on <table name>
if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then
raise_application_error(-20345,'no transaction in sunday');
|Is This Answer Correct ?||7 Yes||1 No|
Answer / rajdeep
create or replace trigger <trigger_name> before insert on <table_name>
if (sysdate,'day') in 'sunday'
raise_application_error(-20500,'cannot insert values on sunday');
|Is This Answer Correct ?||0 Yes||0 No|
what is heap table? : Sql dba
Is primary key is clustered index?
What is snowflake sql?
Is progress software supports to ( pl/sql )?
What is rollback?
Is it possible to create the following trigger: before or after update trigger for each row?
What is orm in sql?
How to avoid duplicate records in a query?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is localdb mssqllocaldb?
Which query operators in sql is used for pattern matching?
How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?