Insert in NESTED TABLE

Author: asktom.oracle.com | Published: 22nd Sep 2007 | Visited: 53 times | Add Comment
Filed in: Oracle FAQ

I am trying to insert rows into NESTED TABLE using simple PL/SQL block and it is writing as single row tham mulple row. Please find the setup scripts CREATE OR REPLACE TYPE CourseList AS TABLE OF VARCHAR2(64); / CREATE TABLE department ( ...

Read Article

Sponsored Links

• External table intermittent errors I'm having a problem with External tables. Most of the time I can read the data in the table without any issue. But when I issue the query below I get an error. <b>Contents of test.csv file</b> <code>Tool type,ID Common,1 Type1,2 Type2,3 ...

• RESTRICT USERS TO INSERT/UPDATE DATA EXCEPT THEIR PRIVILIEGES DEAR TOM i learn a lot from this platform as a new dba i have a situation here. i did't write code/script here because i havn't any idea that how i ask from you? i have tried to convey my.. i have a database of almost 60 tables. application d ...

• LINQ TO SQL All Common Operations (Insert,Update,Delete,Get) in ONE BASE Class Base Class to perform all Common LINQ To SQL Operat ...

• Bulk Insert using ODP.NET Bulk Insert using ODP ...

• MySQL Table Manager MySQL engine permits user level locks. The program explains how to manipulate these lock ty ...

• CodeSnip: How to Select the Records from a Table Following a Pattern without Using ROWNUM In this article Deepankar discusses how to select records from an Oracle 9i table without using ROWNUM. Deepankar provides a detailed analysis of each SQL statement along with the screenshot of the final out ...

• ODP.NET - Populating a Dataset with a Single Data Table ODP.NET - Populating a Dataset with a Single Data Table A dataset is simply a group of data tables. These data tables can be identified with their own unique names within a dataset. You can also add relations between data tables available in a dataset. Visit http://www.exforsys.com to read complete ...

• Create Insert Statements Dynamically Tom,How do you create insert statments dynamically if I give a table name? in TOAD tool, they have this option for each table [Create insert statements] and I was wondering what kind of logic they might have used to create them. I was trying it m ...

• dml single insert/select or bulk collect/forall Tom, i am currently designing a new database 10g Rel2 and would appreciate your advice on the following Which method would you advise for the following business process OPTION 1 ######## DECLARE CURSOR c1 IS SELECT ..........

• Indexes on single Partition of the table I have a table which has been partitioned by the months.Also in the same table i have an indexes in 4 columns. I used partition as we will be loading the data everymonth. We will be having around 9 million rows everymonth. While inserting the rows ...

Next: Using Min/Max in where conditions