Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cc82394

    oracle procedure/package help

    It should also work in pl/sql as a 'insert into table as select...'. declare --whatever you need begin insert into table1 as select a, b, a||b||e||f||d as c from table2; commit; ... end; /
  2. cc82394

    How to tell what Oracle version is installed?

    May not be the best way, but at least to see if it's a database try: ps -ef | grep ora ps -ef | grep LISTENER Hope this helps. Patrick
  3. cc82394

    oracle10g regular expression how to

    Ok I think I figured it out but I made a mistake in my inserts above that need to be corrected. If you ran the dml and ddl from above, then also run this: update np_data set nps_key = 1 where nps_key <> 1; commit; select * from nps a, np_data b where a.nps_key = b.nps_key and...
  4. cc82394

    oracle10g regular expression how to

    create table nps(nps_key number, pname varchar2(10), svalue varchar2(10)); insert into nps values(1,'Paramx','4,5,6'); create table np_data(nps_key number, tstamp date, pvalue varchar2(10)); insert into np_data values(1,sysdate,'4,4,6'); --good match insert into np_data...
  5. cc82394

    oracle10g regular expression how to

    I'm interesting in trying to figure out how to do this using regular expressions as I am trying to get more familiar with regular expressions in Oracle. The standard value is listed as 4,5,6 The actual value received is 4,4,6 The match is because there are 3 numbers X,X,X AND that those three...
  6. cc82394

    oracle10g regular expression how to

    I need to compare values from one column (pvalue) to another column (pstnrd) that holds expected standard values that are complex. I want to use regular expressions. For example the standard is any variation of 4,5,6. A pvalue of 4,4,6 is true and a pvalue 6,8,4 is false when compared to the...
  7. cc82394

    Parallel Port Problem

    Found it. It was disabled in the bios. Thanks for the responses.
  8. cc82394

    Parallel Port Problem

    I tried deleting the ports and rebooting, still nothing. In the bios, in IDE Configuration is where I see the option for &quot;Onboard IDE Operate Mode&quot;. Enhanced mode or compatible mode are the options. Per the manual it seems that if I am using 2000/XP I need to use Enhanced mode, which...
  9. cc82394

    Parallel Port Problem

    In setup I switched it to allow P-ATA and S-ATA, didn't work. Then I tried P-ATA and still not working. In device manager there are 2 ports listed (com1 and com2) in Ports & LPTs. Both ports are enabled. What am I forgetting?
  10. cc82394

    Parallel Port Problem

    New built pc. Where can I check to ensure the port is enabled and addressed correctly? (steps)
  11. cc82394

    Parallel Port Problem

    How can I test my parallel port? I am unable to install my scanner or printer (both using this port). I am thinking the port is not working since I installed the same equipment on my old pc without problems. Thanks.
  12. cc82394

    Windows XP Screensaver Timeout Problem

    View bcastner's response from October 12th, 2 threads prior to yours. This was the final step to get mine working properly.
  13. cc82394

    Windows XP Screensaver Timeout Problem

    bcastner- These last suggestions did the trick, now the screensaver works. Thanks!
  14. cc82394

    inserted more ram and heard . . . . .

    The beeps should be telling you what type of mother board error occurred. Check the mother board manual for a list of error beeps to pinpoint the problem.
  15. cc82394

    Adding a new datafile

    To add a new datafile: alter tablespace <tablespace_name> add datafile <new datafile name with directory> size <number in megs, i.e. 5000M>;
  16. cc82394

    Windows XP Screensaver Timeout Problem

    I have modified HKEY_CURRENT_USER and HKEY_USERS and the problem still exists. ??
  17. cc82394

    Windows XP Screensaver Timeout Problem

    Is setting ScreenSaveActive=1 the solution? Any reason why this happened after a fresh install? Just want to make sure I avoid whatever I did/didn't do for future installs. Thanks.
  18. cc82394

    Windows XP Screensaver Timeout Problem

    I recently installed windows xp pro. After installing the SP and other updates I realized the screensaver was not working. I can only get the screensaver to work if I set the timeout for 1 minute. How can I successfully get the screensaver to work at other timeout periods??? Thanks in advance!

Part and Inventory Search

Back
Top