Hi friends,
i am having a variable declared in .profile.i am changing its value in a shell script and then i am connecting to oracle and then from there i am calling a .sql called update.sql
STATUS is the variable declared in the .profile
===============================
if
sqlplus <<END... (3 Replies)
Hi All,
I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking.
Something like this, through... (3 Replies)
hi folks, I have this data in a data.txt file and i want to sort the 5th column and in descending order: Jun 15 119.167.247.40 = 23 Jun 15 119.167.247.40 = 3 Jun 15 208.115.46.125 = 12 Jun 15 208.115.46.125 = 6 Jun 15 210.51.10.160 = 20 I want this sample output: Jun... (2 Replies)
hi everyone,
i need a script which would just print column into a text file
nmap 10.226.112.222
PORT STATE SERVICE
7/tcp open echo
13/tcp open daytime
22/tcp open ssh
23/tcp open telnet
37/tcp open time
1100/tcp open unknown
above nmap command gives us open ports on that IP. can... (6 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
You will write a script that will read a tab-separated file that contains the names of all 50 states &... (7 Replies)
HI Guys,
Input :- P081 wr1 12p0d5: 22.8
P081 wr1 12p2d18: 23.1
P149 wr1 1pxcud6/port_0_dev_7: 20.4
P149 wr1 1pxcud4/port_1_dev_10: 22.4
OutputP081 wr1 120 22.8
P081 wr1 122 23.1
P149 wr1 10 20.4
P149 wr1 11 22.4
In in First two line delete p and after d untill :
In Last two line... (4 Replies)
Hi,
I need to display specific columns using select statement and spooled to a file and sending it as e-mail. But i am not seeing column header in my output even i use SET HEADING ON.//PREDEFINED LOGIN DETAILS
${ORACLE_HOME}/bin/sqlplus -s ${DB_LOGIN}/${DB_PASSWD} <<EOF
SET FEEDBACK OFF
SET... (1 Reply)
Example:
I have files in below format
file 1:
zxc,133,joe@example.com
cst,222,xyz@example1.com
File 2 Contains:
hxd
hcd
jws
zxc
cst
File 1 has 50000 lines and file 2 has around 30000 lines :
Expected Output has to be :
hxd
hcd
jws (5 Replies)
Source Code of the original script is down below please run the script and try to solve this problem
this is my data and I want it column wise
2019-03-20 13:00:00:000
2019-03-20 15:00:00:000
1
Operating System
LAB
0
1
1
1
1
1
1
1
1
1
0
1 (5 Replies)
Discussion started by: Shubham1182
5 Replies
LEARN ABOUT PHP
db2_field_display_size
DB2_FIELD_DISPLAY_SIZE(3) 1 DB2_FIELD_DISPLAY_SIZE(3)db2_field_display_size - Returns the maximum number of bytes required to display a columnSYNOPSIS
int db2_field_display_size (resource $stmt, mixed $column)
DESCRIPTION
Returns the maximum number of bytes required to display a column in a result set.
PARAMETERS
o $stmt
- Specifies a statement resource containing a result set.
o $column
- Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a
string containing the name of the column.
RETURN VALUES
Returns an integer value with the maximum number of bytes required to display the specified column. If the column does not exist in the
result set, db2_field_display_size(3) returns FALSE.
SEE ALSO db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_type(3), db2_field_width(3).
PHP Documentation Group DB2_FIELD_DISPLAY_SIZE(3)