Search results for query: *

can anybody explain the below where clause: ORA-O*(600?|7445|4[0-9][0-9][0-9])[^0-9] i get the general idea of it but dont understand the ? after the 600 and the reason for the last [^0-9] outside of () . i know ^ means end of line. thanks.

thanks for your responses. the $C_DATE=$user_date`date +%a%b%e` doesn't quite produce what i'm after, output: Tuesday January 11 08:38:30 EST 2005TueJan11 the output from: $ C_DATE=`date +"%a %b %e "` $ echo $C_DATE Tue Jan 11 i can format this in the output required. thanks.

i am trying to use the "date" options on a user defined date variable. is this possible? $ user_date=`date` $ echo $user_date Monday January 10 15:01:25 EST 2005 $ C_DATE=`$user_date +"%a %b %e "`

thanks for the help

hi, i am trying to use sed to replace a single space in a date variable with a double space and then use that value to find all entries in a log file: num_day="8" C_HOUR="13" C_DATE='Wed Dec 8' C_DATE="`echo $C_DATE | /bin/sed -e 's/'${num_day}'/ '${num_day}'/'`" # replaces day number with...

thanks for the reply, hmckillop. i also found that those columns were missing from some of the system tables. don't know how or why? restored msdb from backup.

receiving the below error when trying to add a new job from sql server agent: SQL-DMO ODBC Sqlstate: 42S22 error 207: invalid column name 'category_id' invalid column name 'netsend_address' invalid column name 'last_netsend_date' invalid column name 'last_netsend_time'. the version is...

i have 2 tables: Cust( CustomerID int, CompanyName varchar(20), City varchar(20)) CustOrder (OrderID, CustomerID foreign key references Cust(CustomerID)) i am getting error when trying to load xml file: "no data was provided for column 'OrderId' on table 'CustOrder'." the xdr schema is...

i'm trying to use openxml to insert xml data to a table. is it possible to load an xml file with sp_xml_preparedocument, i.e. specify a path and filename c:\tmp\new_xml.txt that contains xml data.

i am writing a bourne shell script to append to each line in a text file a return character (new line) then followed by 'go' using: #!/bin/sh cat ${format_file_name}.out | /bin/sed -e 's/$/^Mgo/g' > junk.lst example of row in file ${format_file_name}.out: table1 table2 table3 using <ctrl...