Hi
I am ETL person.
I have a table in Oracle having one of its column defined as BLOB
where it can hold huge data.
When i generate a file in DataStage and place it in a path.
and i would like dump the file in to the column of the table having datatype as BLOB. (0 Replies)
Hi, Iam new to unix. I have one input file .
Input file :
ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3
I need output such that only first column should change to fixed width column of 15 characters of length.
Output File:
ID1<<12 spaces>>Name1~Place1
ID2<<12... (5 Replies)
Hi All,
in bash I have a text file which is something like
7.96634E-07 1.0000 0.00000E+00 0.0000 0.00000E+00 0.0000 1.59327E-06 0.7071
2.23058E-05 0.1890 6.61207E-05 0.1098 1.13919E-04 0.0865 1.47377E-04 0.0747
....
....
0.00000E+00 0.0000 0.00000E+00 0.0000 ... (6 Replies)
Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
Hi,
I have an ascii file containing information. This file is n x m lines.
Is there a way to generate an ascii file where the information is stored as n x m table instead? The m columns should be tab separated.
Thanks a lot,
Sarah (11 Replies)
This is my input file :
# cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9
This is the required output
... (1 Reply)
Hi all, looking for some help here. I'm what you'd call a dirty programmer. my shell scripts might be ugly, but they (usually) function...
Say I have a single column text file with a list of dates (yyyymmdd) that represent the elevation of a point on that date (I work with land subsidence, so... (2 Replies)
please write a shell script
Table
--------------------------
1 2 3 a b c
3 4 5 c d e
7 8 9 f g h
Output should be like this
---------------
1 2 3
3 4 5
7 8 9
a b c
c d e
f g h (1 Reply)
Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records
Table
---------
Col1 col2 col3 col4 ....................col20
1 2 3 4 .................... 20
a b c d .................... v
... (11 Replies)
Discussion started by: Priti2277
11 Replies
LEARN ABOUT PHP
mysql_fetch_field
MYSQL_FETCH_FIELD(3) 1 MYSQL_FETCH_FIELD(3)mysql_fetch_field - Get column information from a result and return as an objectSYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_fetch_field(3)
o PDOStatement::getColumnMeta
object mysql_fetch_field (resource $result, [int $field_offset])
DESCRIPTION
Returns an object containing field information. This function can be used to obtain information about fields in the provided query result.
o $
result -The result resource that is being evaluated. This result comes from a call to mysql_query(3).
o $field_offset
- The numerical field offset. If the field offset is not specified, the next field that was not yet retrieved by this function is
retrieved. The $field_offset starts at 0.
Returns an object containing field information. The properties of the object are:
o name - column name
o table - name of the table the column belongs to, which is the alias name if one is defined
o max_length - maximum length of the column
o not_null - 1 if the column cannot be
NULL
o primary_key - 1 if the column is a primary key
o unique_key - 1 if the column is a unique key
o multiple_key - 1 if the column is a non-unique key
o numeric - 1 if the column is numeric
o blob - 1 if the column is a BLOB
o type - the type of the column
o unsigned - 1 if the column is unsigned
o zerofill - 1 if the column is zero-filled
Example #1
mysql_fetch_field(3) example
<?php
$conn = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$conn) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db('database');
$result = mysql_query('select * from table');
if (!$result) {
die('Query failed: ' . mysql_error());
}
/* get column metadata */
$i = 0;
while ($i < mysql_num_fields($result)) {
echo "Information for column $i:<br />
";
$meta = mysql_fetch_field($result, $i);
if (!$meta) {
echo "No information available<br />
";
}
echo "<pre>
blob: $meta->blob
max_length: $meta->max_length
multiple_key: $meta->multiple_key
name: $meta->name
not_null: $meta->not_null
numeric: $meta->numeric
primary_key: $meta->primary_key
table: $meta->table
type: $meta->type
unique_key: $meta->unique_key
unsigned: $meta->unsigned
zerofill: $meta->zerofill
</pre>";
$i++;
}
mysql_free_result($result);
?>
Note
Field names returned by this function are case-sensitive.
Note
If field or tablenames are aliased in the SQL query the aliased name will be returned. The original name can be retrieved for
instance by using mysqli_result::fetch_field.
mysql_field_seek(3).
PHP Documentation Group MYSQL_FETCH_FIELD(3)