Questions tagged [bulk-collect]
84 questions
0
votes
1 answer
Oracle dynamic table creation on runtime
I make to try a search engine.Scenario like that; I have a table that it contains text context and I'm fetching some records what suitable according to my query then I want to transfer this founded text of id on a table that created dynamicly on…
Goran Zooferic
- 371
- 8
- 23
0
votes
1 answer
Fetching a single column with dynamic query
I want to fetch a single column into an array. I am using following code
TYPE t_column IS TABLE OF TABLE_1.COLUMN_1%TYPE INDEX BY PLS_INTEGER;
ar_column t_column;
Then the query is something like
select column_1 from table_1 where column_1 =…
Em Ae
- 8,167
- 27
- 95
- 162
0
votes
1 answer
how dows bulk update flow of execution works
I am putting up some code which will be copying billions of data from one table to another and we don't want the procedure to stop in case of exception. so i am putting up the script like (not putting 100% compilable syntax)
dml_errors …
Em Ae
- 8,167
- 27
- 95
- 162
0
votes
2 answers
PL/SQL Bulk Collection Insert syntax
I am tasked with inserting a new transaction_code into a table which contains a min_cost and max_cost from the same table. What I am trying to do is take the min_cost from counties with a transaction code of 2 and the max_cost from counties with a…
user2405778
- 467
- 6
- 16
- 29
0
votes
2 answers
Oracle PL/SQL - Bulk Collection usage into WHERE and FROM clause inside conditions and inner views
I have a strange problem using bulk collection as element of FROM clause.
When I execute this code example, I get, just at run-time, the error "invalid table name".
If I replace the collection with a table everything works well.
Is there any…
frank86ba
- 23
- 6
0
votes
2 answers
Copy data from a table and load it into another table
I have a table 'A' having 40 columns. I need to copy the data from 20 specific columns from 'A' , to another table 'B' having those 20 columns. There will be around 3 - 10 million records.
What will be the most efficient way to do this in PLSQL.
cool_mo
- 15
- 1
- 3
0
votes
1 answer
Oracle Bulk Collection Script to Insert Data
I have the following script
DECLARE
CURSOR cursor1 IS
SELECT *
FROM table1;
TYPE cursor_aat IS TABLE OF cursor1%ROWTYPE;
l_cursor cursor_aat;
BEGIN
OPEN cursor1;
LOOP
FETCH cursor1
…
Paul Michaels
- 16,185
- 43
- 146
- 269
-1
votes
1 answer
How to Optimize PL/SQL code using Bulk collect/FORALL?
pl/sql code taking too much time to remove characters in all tables
begin
for i in ( select TABLE_NAME,COLUMN_NAME from all_tab_columns
where owner='BILL' and data_length > 1 and table_name not like 'SYS_EXPORT_SCHEMA%' and…
-2
votes
1 answer
how to append bulk fetched rows to a table type in oracle?
I'm bulk collecting records from Cursor-B for every record in cursor-A, is there any way to append this Cursor-B data to a table type so that i can insert it into a table at once ?
I cannot combine cursor-A and Cursor-B SQL.
I know BULK COLLECT…
Dunbay
- 9
- 1
- 2