Interested to Buy Any Domain ? << Click Here >> for more details...
if i am using dml statement in function.
then i am writing select statement what was the output
- 2 Answers
- 4282 Views
- MasterCard, I also Faced
- E-Mail Answers
Answer Posted / jayashree
DML cant be performed in Function. There would be no change.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is an external table?
What is a dynamic performance view in oracle?
What does sharding mean?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to export data to a csv file?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Explain do view contain data?
What is the string concatenation operator in oracle?
How to use like conditions in oracle?
Write a syntax for update query in oracle?
What are the general rules on data consistency?
What are privileges and grants?
What are the tools for Oracle ?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
