Can we perform dml in function?
No Answer is Posted For this Question
Be the First to Post Answer
What is sqlexception in java?
What language is oracle sql developer?
Show how functions and procedures are called in a pl/sql block.
What is pivot in sql?
What does (+) mean in sql joins?
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 -- -- --
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.....
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.
What is cte sql?
What are the 3 types of behavioral triggers?
What is dml and ddl?
How can you load microsoft excel data into oracle? : aql loader