Recent content by hameja

HI, I want to insert the results into a table called farm_dups fields are msisdn, amount, adate. Please amend my scripts if possible.

Hi Gentmen Im trying to write a PL/SQL program but the program is not doing anything. Please look at my code and advise or modify Declare 2 Cursor farm is 3 Select 4 min_in_2.msisdn,substr(min_in_2.datehour,1,8) 5 From min_in_2, farm_win 6 Where 7...

Hi People I have done all what I have been advised to do but I cant still see the hard drive. I have started the servers from smartstart Kit broken thour to command line but still I cant see the disks. I downloaded the drivers but it requires me to log in as root to run rpm. What next John

Hi People May somebody out there help. I need to configure this linux server but I can see the disks. Somebody had ealier suggested that I need to download the scsi drivers but I have gone to HP site I can't still find the drivers to donwload. How can I get these drivers and what do I need to...

Thanks but how do I get these drivers? which website and what next. When I press f8 im able to see the logocal drives but the moment. Its a g4

Hi Gurus, I have 2 HP DL380 Servers that I want to install Linux Red had es 3.0. Each time I run an installation Im getting a message that no devices installed. I would like to see the hard drives. I cant even boot as single user mode. How can I go about this ?

Im trying to configure webserver using Linux 8 Red Hat. Im getting this message when I open a web page "Operation timed out when attepting to contact "www.xxx.com" where can I change this time. Secondly when I run httpd start Im getting an error "sysntax error port must be specified" Help

How do I configure to send sms from linux ? I have got the smpp connection to the smsc

Hi Gurus I brought down Solaris box yesterday and during booting I was advised to run FSCK. I tried to run metastat I got a response of no database installed and then I run prtdiag -v HDD0 reported amber light. Is there any more command that that report errors on that disk. John

How do you check if disks are mirrored in Linux?. Solaris uses metastat

how can I select duplicate records in a table that is not indexed

No I mean select * from tbl where rowcount </> number

Hi People Is there any function in Oracle like Row count

Yes currency is a varchar error invalid number

Is coming wioth an error invalid number look at this select distinct(ltrim(method)) "METHOD", substr(datehourmin,1,8) "DATE" to_num(currency) from min_in group by method,substr(datehourmin,1,8) I want to sum on this field. John