Search results for query: *

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...

No idea. The DBAs are referring to the 10g database as the HP database. Maybe I can decode the version number into HP for my purposes. Thanks for trying though - I did learn a bit and will tuck that knowledge away. Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard...

Thanks for trying again. I don't have privileges to change any parameters. The server host yields yet another name: SQL> Select substr(sys_context('USERENV','SERVER_HOST'),1,30) server_host from dual; SERVER_HOST ------------------------------ ofw1 SQL> Seems like it shouldn't be this...

Black and Gus Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)

Not that I expect it, it is what I need for literally hundreds of testing scripts to be self-documenting. It sounds like what I might need is the DB_DOMAIN and DB_NAME parameter values. Is there a way for me to be able to select those values to create the actual database name we connect to...

Here I am just a developer without those kinds of privileges. When I inquired about it, the answer I received from the state DBAs is that the name must be identical for migration purposes. Beware of false knowledge; it is more dangerous than ignorance. ~ George Bernard Shaw Consultant...