08-25-2005
as a beginner you won't perhaps know this (and, besides, this is most often ignored by even the most veteran UN*Xers): 'echo' should not be used. Use "print" instead:
print - "abc\tdef"
will do exactly what you want - regardless of what version of print you are using.
bakunin
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I've tried this:
echo "${bold}User${norm} : u"\t"${bold}All Users ${norm} : a\t"
and i got this output:
Specific User : u\tAll User: a\t (14 Replies)
Discussion started by: laila63
14 Replies
2. UNIX for Dummies Questions & Answers
I have input like:
1234567890
cut -c1-3,6-7,9-10 input > output
Now I got 1236790.
I want to insert space between each cut. So the output like:
123 67 90
Can anybody help?
Thanks. (7 Replies)
Discussion started by: sslr
7 Replies
3. Shell Programming and Scripting
Hi,
I'm using the following to insert lines into file:
sed ${rowNr}i'\
first row\
second row\
third row\
' file.txt
How can I add tab in front of each added line? "\t" or actual TAB does not seem to work?
Thanks! (2 Replies)
Discussion started by: Juha
2 Replies
4. Shell Programming and Scripting
Hi All,
I am using Unix ksh script.
I need to insert values to a table using the o/p from a slelect statement.
Can anybody Help!
My script looks like tihs.
---`sqlplus -s username/password@SID << EOF
set heading off
set feedback off
set pages 0
insert into ${TB_NAME}_D... (2 Replies)
Discussion started by: nkosaraju
2 Replies
5. Shell Programming and Scripting
trying to insert a LF and 2 TABs for this:
sed 's/<td><\/td>/<td>\n\t\t<\/td>/' infile.
but, I'm not getting the syntax for inserting the LF and TABs correct (1 Reply)
Discussion started by: dba_frog
1 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have the following code:
LIST=`ls | grep '.sql$'`
echo $LIST
The above code will give me something like..
file1.sh file2.sh file3.sh file4.sh file5.sh
I want to display the values into rows using echo like...
file1.sh
file2.sh (5 Replies)
Discussion started by: adshocker
5 Replies
7. Shell Programming and Scripting
Hi ,
I have a file with 5 colums each are sererated by tab. I am reading each line and adding extra two columns , the value depends on 5th column..
Now am trying to store each and every record in another file..
using the command echo $line $6thcol $7th col
$line - readin the each... (2 Replies)
Discussion started by: arukuku
2 Replies
8. UNIX for Dummies Questions & Answers
Hi all,
I have this:
begin data;
dimensions nind=168 nloci=6;
info
BDT001.4 ( 1 , 1 ) ( 1 , 12 )
BDT003.4 ( 1 , 1 ) ( 12 , 12 )
BDT007.4 ( 1 , 1 ) ( 12 , 12 )
BDT009.4 ( 1 , 32 ) ( 12 , 22 )
etc, etc
And need this:
begin data;
dimensions nind=168 nloci=6;
info
... (2 Replies)
Discussion started by: MDeBiasse
2 Replies
9. UNIX for Dummies Questions & Answers
I have several lines in a file that I want to replace a space with a tab.
For example:
111047 Julie Jones email@email.com
111047 Julie Jones email@email.com
I want to replace the space after the word "jones" with a tab.
How do I achieve that in Vi?
Please assist.
Thanks! (5 Replies)
Discussion started by: onlinelearner02
5 Replies
10. Shell Programming and Scripting
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
LEARN ABOUT PHP
oci_field_name
OCI_FIELD_NAME(3) OCI_FIELD_NAME(3)
oci_field_name - Returns the name of a field from the statement
SYNOPSIS
string oci_field_name (resource $statement, mixed $field)
DESCRIPTION
Returns the name of the $field.
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns the name as a string, or FALSE on errors.
EXAMPLES
Example #1
oci_field_name(3) example
<?php
// Create the table with:
// CREATE TABLE mytab (number_col NUMBER, varchar2_col varchar2(1),
// clob_col CLOB, date_col DATE);
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
$stid = oci_parse($conn, "SELECT * FROM mytab");
oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows
echo "<table border="1">
";
echo "<tr>";
echo "<th>Name</th>";
echo "<th>Type</th>";
echo "<th>Length</th>";
echo "</tr>
";
$ncols = oci_num_fields($stid);
for ($i = 1; $i <= $ncols; $i++) {
$column_name = oci_field_name($stid, $i);
$column_type = oci_field_type($stid, $i);
echo "<tr>";
echo "<td>$column_name</td>";
echo "<td>$column_type</td>";
echo "</tr>
";
}
echo "</table>
";
// Outputs:
// Name Type
// NUMBER_COL NUMBER
// VARCHAR2_COL VARCHAR2
// CLOB_COL CLOB
// DATE_COL DATE
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumnname(3) instead. This name still can be used, it was left as alias of
oci_field_name(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO
oci_num_fields(3), oci_field_type(3), oci_field_size(3).
PHP Documentation Group OCI_FIELD_NAME(3)