Search results for query: *

Hi when i start my Apache, i get a series of error messages in the error_log file: [Wed Jul 17 11:33:00 2002] [notice] jrApache[init] mod_jrun: JRun Connector v2.3.149 static Apache - Aug 12 2001 23:28:43 [Wed Jul 17 11:33:01 2002] [notice] jrApache[init] mod_jrun: JRun Connector v2.3.149...

Hi i have a series of user parameters that i would like to 'build' a date from for a comparison against a date field in a table. the parameters are &dd, &mon, &yyyy, &hh24 and &mi. how can i put them together in the format &dd:&mon:&yyyy:&hh24:&mi:00 in order to use them in a date comparison...

Hi I wish to select the distinct year from a series of rows in a table. the date column is in the format dd:mon:yyyy:hh24:mi:ss, how do i retrieve the distinct year part from these rows? Thanks in advance Stephen

Hi using Oracle 8.1.7.2 I wish to create a series of views that contain date portions in order to populate drop down boxes. I wish to create seperate views of: Days Months Years Hours Minutes I have a table that is loaded with data every night, this table contains date entries in the format...

Hi i am using oracle 8.1.7.2 and need to have an alternative within a select statement. I am calculating the percentage failure from some data (failure/attempts) * 100 there is the potential for the attempts to = 0, so this will potentially produce an error in the select statement. how do i...

I have managed to find a compound statement to perform what i am looking for: select SUBSTR( CUSTOMER_SITES.NAME, 0, ((INSTR(CUSTOMER_SITES.NAME, '-', 1,1)) -1)) Is there a simpler way of performing this select??

Sorry I am using Oracle 8.1.7.2

Hi I wish to select from a column, the names of customers. These names are in the format: "customername-location". how can i ignore everything after the "-" character and just select the customername section? i have looked at the substr() function, but as the customername...