Search results for query: *

I'm not sure what you want to do - are you looking for a way to set the data in one column to null? If so, you can do an update like jimbopalmer suggested - update tbl set Jan = null

You can't specify a where clause for a truncate, but you can for the delete command: delete from tbl where month = 'dec'

The utl_file utility can be used to load files that are on any network computer - you have to set the file path parameter like this: utl_file.fopen('\\pathToTheFile', 'myfile.txt', 'r'); This will open the file for read access. You can then read the file line by line using the get_line function.

Another way you can do this without changing the trigger is by adding a returning clause to the insert: insert into mytable(x, y) values(:a, :b) returning id into myIdVar; The trigger will populate the id column and the value will be returned into the myIdVar variable, which you can then use...

Yes, you would need a commit after executing a DML statement using execute immediate.

I will send you a pared down version - it's a rather complicated process, but I can send you snippets of the relevant code. I was very surprised to see what was happening too - but I put in a dbms_output immediately before the called procedure returned and then immediately after, and sure...

Hi. The error was on your_tab(your_tab.last), which should have existed - in the called procedure, your_tab.exists returned true, but once it returned to the main procedure, exists returned a false.

Hi. If you know what the plan is you'd like to see, you can specify it in a hint - to use a nested loop join, you can use the use_nl(table_a, table_b) hint. Have you tried doing this? (It will join the tables in the order listed inside the parenthesis.)

Try putting a hint in the query - /*+rule*/. This will prevent Oracle from using the statistics when creating the execution plan.

I don't know how I'm getting the error - I'm definitely within the bounds of the collection. The size of the table is between 20 and 200 records. Someone here at work gave me a workaround option - instead of using a plsql table, I am using a temporary table - create global temporary table...

I don't know how I'm getting the error - I'm definitely within the bounds of the collection. The size of the table is between 20 and 200 records. Someone here at work gave me a workaround option - instead of using a plsql table, I am using a temporary table - create global temporary table...

The table is not an index-by table (in your example, you were using a table declare as index by binary_integer) - for such a table, you are right. This is a nested table, so the indexes are incremental (1, 2, 3...) and you should only see a no_data_found if a specific record has been deleted.

Try one of these methods inside the procedure: dbms_output.put_line('value of myvar:' || myvar); TOAD has a display screen for output generated through dbms_output - just make sure to turn output on (the button should be green, not red) or you can output to a file: declare a file handle -...

I am using a plsql table to store records within a procedure. This table is passed to an outside procedure as an in/out parameter. The second procedure adds records using the extend method on the table and then returns. At that point I sort the table but I am finding that the last records in...