Can we perform dml in function?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is sqlexception in java?

0 Answers  


What language is oracle sql developer?

0 Answers  


Show how functions and procedures are called in a pl/sql block.

0 Answers  


What is pivot in sql?

0 Answers  


What does (+) mean in sql joins?

0 Answers  






Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  


i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  


I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers  


What is cte sql?

0 Answers  


What are the 3 types of behavioral triggers?

0 Answers  


What is dml and ddl?

0 Answers  


How can you load microsoft excel data into oracle? : aql loader

0 Answers  


Categories