Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Creating a multi-Valued table in Oracle ver > 8.15 using SQL PLUS
Agreed that a seperate relational table is the way to go. Supports first normal form. But I would put all numbers on the same table and have an attribute marking primary contact number (or a ranking of contact numbers to be able to sort by importance) if desired. This makes coding much...- amarkiew
- Post #4
- Forum: Oracle: All versions
-
Regex to uppercase tags
$tag ='<form action="http://ddd.com"; method="post">'; print "TAG = $tag\n"; $tag =~ s/(.*?)(".*?")/uc($1).$2/eg; print "TAG = $tag\n"; Output: TAG = <form action="http://ddd.com"; method="post"> TAG = <FORM... -
DBI assistance
my @values = qw(03-10-2002,02:20:20); should have a space instead of a comma. qw() does not consider a comma a delimiter. -
DBI assistance
I don't use the CSV in the DBD module but these should still apply. You can get the column names of a statement using the statement attribute NAME, NAME_uc or NAME_lc. EX: my $dbh = (... however you connect...); my $stmt = qq(select * from table); my $csrStmt = $dbh->prepare($stmt); my @cols =... -
fooling me for ages....
A few thing I see may be potential problems. I don't think you have anything in @newcode. It looks like you take $code and send it to a file with FH CODE2 and then try reading it into @newcode with FH CODE. But the OPEN statement for CODE is for output not input which will make @newcode null...
