Interested to Buy Any Domain ? << Click Here >> for more details...
how to we delete a row using varray
- 3 Answers
- 4481 Views
- CTC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ganga
We can't delete records from varray by using delete method.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / dinesh
Yes we can not delete single element from varray using DELETE method but we can delete last element from VArray using TRIM method
means if your varray name is V1 then
V1.trim delete last element from varray.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dinesh
Type CC is Varray(5) of number;
c CC:=CC(1,2,3,4,5);
Begin
c.trim /* Delete last 5th Element with thier place holder from varray*/
c.trim(3)/*remove last 3 element with thier place holder from varra
c.delete/* delete all the varray.
| Is This Answer Correct ? | 0 Yes | 0 No |
How many types of synonyms in Oracle?
Explain the different normalization forms?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What is an Oracle sequence?
can u plz provide me oca sql dumps please i need them
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
what is the uses of cusor
How to display First 4 rows From Database Table?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
what is difference between sql plus and sql*plus? (not sql and sql plus).
what is host string in sql plus? how does it related to database?
Oracle General 
