Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is oracle server autotrace in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
Describe varray?
How can we view last record added to a table?
How to upsert (update or insert into a table)?
Can we insert data in view oracle?
How to use in conditions in oracle?
How to create a stored function in oracle?
What is analyze command used for?
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.
What is the scope of a local variable?
How to create an oracle database?
What is a table in oracle?
is there a tool to trace queries, like profiler for sql server?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
