Search results for query: *

hi, I have what i thought was a simple inner query ( new to SQL), i want to first return all records where the time is between a and b and then query the results to find num. i cant see whats wrong with it, any ideas? SELECT NUM FROM CC_SESSION_TABLE WHERE SESSION_NUM =...

here you go CREATE OR REPLACE PROCEDURE UPDATE_INSERT_LAST_CALL( val_msisdn IN VARCHAR2, val_imei IN VARCHAR2, val_imsi IN VARCHAR2, val_call_date IN VARCHAR2) AS val_count NUMBER; val_count1 NUMBER; old_imsi NUMBER; old_imei NUMBER; BEGIN dbms_output.put_line('The next...

i managed to do it, i never wrote SQL before so got my head around it in the end.

Hi i have a SP below. which does the following, it takes a triplet of values (msisdn,imei, imsi) and based on the timestamp with the triplet either inserts into table A or Updates the Triplet Timestamp in table A if exists, while also writing to Table B. A = ACTIVE_HANDSETS B =...

hi, can anyone tell me whats the best way to return the column names for each table to a perl script. I have written a script that retrieves all the values in a table and formats it into HTML. The only thing is that I am unsure how to retrieve the column names. The perl module installed does...

Hi, Would that all work if Test2.pm was Test2.pl ?? im having a similar problem

cheers it was permissions!

Hi, im getting this "Couldn't rename at ftp.pl line 20" looks like its not picking up the file name??

Hi, I am trying to rename files ona remote server using this simple bit of code, but it doesnt work, can anyone point out what im doing wrong? cheers Jon #!/usr/bin/perl use Net::FTP; $ftp = Net::FTP->new("localhost", Debug => 0); $ftp->login("anonymous",'-anonymous@')...

thanks guys, much appreciated!

cheers for the help guys, one more thing .. so can i have @list = qx{find $DIR -name "file" -exec ls {} \\;}; print "@list\n"; or am i being too simple here? :)

hi sorry, in the case of system(qq[find $DIR -name "file" -exec ls {} \\;]); this prints out all the files to the screen when i execute the script. in the case of qx{find $DIR -name "file" -exec ls {} \\;}; this prints nothing at all? I thought qx and system where similar?

hi, why in perl does this return what i want: system(qq[find $DIR -name "file" -exec ls {} \\;]); but this returns nothing? qx{find $DIR -name "file" -exec ls {} \\;}; where $DIR = directory read in from input. Its bugging me!!

cheers for responding. abit of background would help i suppose. I want to the program to be able to start a x25 session to a HLR. in the perl script i will have options for the user to specify the HLR they wish to connect to, this will then open a shell towards this network node that the use...

Hi, Im trying to start an x25 session from within a perl script. Basically im trying to create a small script which allows a user to enter an x25 address, the script will then execute a x25 command and connect to a device and display the shell of the device so that it can then receive commands...