Recent content by cc82394

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; /

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

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

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

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

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

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

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

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?

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

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.

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

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

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.

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