Interested to Buy Any Domain ? << Click Here >> for more details...
wtite down triggr not any entry on Sunday
- 2 Answers
- 6336 Views
- NIT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / debasish sinha
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;
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / rajdeep
create or replace trigger <trigger_name> before insert on <table_name>
begin
if (sysdate,'day') in 'sunday'
then
raise_application_error(-20500,'cannot insert values on sunday');
end if;
end;
| Is This Answer Correct ? | 0 Yes | 0 No |
What is rule base and cost base optimizer?
Is sql a microsoft product?
What is the purpose of my sql?
what are sequences
What is synonyms?
What is sql profiling in oracle?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
What is pl sql record in oracle?
What is an invalid partition table?
How is use pl and sql?
How can we make an if statement within a select statement?
What is sql not null constraint?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
