Tag Info

New answers tagged

1

Test case. Open 2 sqlplus sessions, run the following in the first to set the test up: create table stall_table ( a number ); create or replace trigger stall_session before insert on stall_table begin DBMS_LOCK.sleep(10000); end; Then, execute in session 1: SQL> insert into stall_table values ( 1 ) ; Execute in session 2: SQL> create or ...


1

It is just a fact of life. Different history, different beliefs, different goals. Your might find this post on PL/SQL and its goals helpful in seeing some of the differences: http://docs.oracle.com/cd/B10501_01/appdev.920/a96624/03_types.htm It amusingly starts with: Like--but oh how different! --William Wordsworth There are ANSI Standard data ...


1

That's relatively easy. Using the UTL_FILE package in Oracle you can create a file in the servers filesystem and write the output of any PL/SQL statement to it. You can actually also use it to read data from a file. http://psoug.org/reference/utl_file.html You might also want to read up a little on the Directory object type as well, since that's a ...


1

Find a small recordset and see how many loops your code does. How many does it do for 10, 100 and 1,000 records? You will see that the number of loops increases exponentially as the number of rows increases. My rough guess is that you have asymptotically big O(2^n+2^n+2^n). Asymptotics is a way of estimating work where the amount of rows processed is not ...


0

There is no valid reason to use it. It is simply a lazy shortcut specially designed to make it difficult for some hard-pressed developer to figure out your grouping or sorting later on or to allow the code to fail miserably when someone changes the column order. Be considerate of your fellow developers and don't do it.



Top 50 recent answers are included