i have seen alot of people here solve their problem by creating a table..
can anyone explain the use of the table create?
the advatage and disadvantage or it..
is the table create really in the database or just virtually?
any more info would be welcome..
There are database tables (CREATE TABLE ...) and there are collection data type also called tables (just to confuse everyone!)
Database tables are permanent objects and should not be created by your programs.
Programs may make use of collections for storing data in memory for processing - e.g.:
2 TYPE ename_tab_type IS TABLE OF emp.ename%TYPE INDEX BY BINARY_INTEGER;
3 ename_tab ename_tab_type;
5 SELECT ename BULK COLLECT INTO ename_tab FROM emp;
6 FOR i IN 1..ename_tab.COUNT LOOP
8 END LOOP;