Recent content by BJCooperIT

My chemistry teacher insisted that if you placed two pots, one filled with cold water and the other filled with room-temperature water, on stover burners set on high, the pot with cold water would come to a boil first! Beware of false knowledge; it is more dangerous than ignorance. ~ George...

Great explanation, Carp. Have a star on me. Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)

Was the second account granted its privileges directly or through a role? Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)

I created a table with the code indexed. I then wrote a script to load an array and use it on 1,000,000 rows and then the used the SELECT on 1,000,000 rows. The array took 9 seconds compared to the SELECT which took 38 seconds. Not a huge savings on 10,000,000 rows, but a savings nonetheless...

We have gotten a little off-track here with SUBSTR's and LIKE's since neither are part of my problem. Adding a column to the table does not improve performance since the IF statement would have to be replaced with a SELECT. It only makes sense that adding 10,000,000 selects of the table is...

Thanks for your responses. Actually, the codes are in a table with a unique index on the code. Problem is, this agency of the government is not interested in adding a column to that table so that I could distinguish between those particular codes and the others stored there. My task is to look...

Oh I wish I were an Oscar Mayer weiner. Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)

My client has a procedure in a package that has an IF statement that is repeated in four separate places. It reads something like this:IF v_code IN ( 'CA','CF','CN','CT','JO','ND','NT','P1','P3', 'PA','PB','PC','PD','PE','PF','PH','PJ','PK'...

My problem is finally resolved. The Oracle Developer Suite was improperly installed. Hope that helps someone. Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)

Very nice! Thanks for taking the time to share. Have a star on me. Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)

I have Oracle 10(g 10.2.0.1.0) installed on my PC. My problem is that when I start an OC4J listener and then try to run a form from Forms Builder, the browser opens to a white page that says "ORACLE FORMS." and then stops. My Forms Builder Runtime Preference for Application Server URL is...

A well-deserved star from me, too! Thanks for everyone's help. Talking to the client, apparently the aversion to %TYPE is simply a personal preference of the head DBA. [ponder] Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw Consultant Developer/Analyst...

I have inherited a set of PL/SQL coding standards written in 2007 for an Oracle 8i database. My task is to make recomendations to update these standards for 10g. While I am sure I might have more later, right now I have two questions. 1. The original standards state that public procedures...

Does this help? SQL> SELECT ilv.*, ROWNUM new_rn, 2 decode(MOD(ROWNUM,3),0,3,MOD(ROWNUM,3)) calc 3 FROM (SELECT tt.*, 4 ROWNUM rn 5 FROM test_tab tt 6 ORDER BY num_logins DESC) ilv 7 ; NUM_LOGINS DEVELOPER RN NEW_RN...

One often misunderstood Oracle concept is the use of ROWNUM. The example below shows ROWNUM, labeled “RN” on an unsorted query. NUM_LOGINS DEVELOPER RN ---------- ---------- ---------- 43 WHITE 1 27 BLACK 2 15 PINK 3...