Interested to Buy Any Domain ? << Click Here >> for more details...
how can we write trigger in trigger????????
can we write one trigger on two table???
- 2 Answers
- 5832 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / abhisudipta
Yes , I am again, my previous answer is correct only for the
2nd question.
In case of the 1st question: I would like to say that if we
use execute immediate in a procedure or function , there
write the script of creating the new trigger and then that
procedure/function is being called from the trigger body
then only it works.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between pre-select and pre-query?
How to create a table interactively?
What the is the diff between local index and global index. give some example.
What is oracle data type?
How can I combine multiple rows into a comma-delimited list in oracle?
Compare and contrast between sql and sql server and explain its various functions?
How to define a variable to match a table column data type?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Is oracle a relational database?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to check your oracle database 10g xe installation?
How to write numeric literals in oracle?
What are joins, explain all types of joins?
How can windows applications connect to oracle servers?
