Hello gurus,
I have data in one of the oracle tables as as below:
fyi, Column 2 above has data delimited with a comma as shown.
I need a sql query the produce the below output in two columns as.
Basically, I need to split data in one field based on a delimiter which is a comma and then normalize the data to get the required output. I have been trying sql using regex but without success. Any inputs are appreciated.
Thanks,
Carl
Moderator's Comments:
edit by bakunin: please use CODE-tags for data and file content too. Thank you.
This is basically what I want to do:
I have a file that contains single lines of IDs.
I want to query the oracle database using these IDs
to get a count of which ones match a certain condition.
the basic idea is:
cat myfile |
while read id
do
$id in select count(PC.ptcpnt_id)
from... (4 Replies)
Hi,
I have data in my text file something like this.
adams
robert
ahmed
gibbs
I want to use this data line by line as input to an sql query which i run by connecting to an oracle database from shell.
If you have code for similar scenario , please ehlp.
I want the output of the sql query... (7 Replies)
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
All,
Can anyone please help me with the below scenario.
I have a Flat file of the below format.
ID|Name|Level|Type|Zip|MAD|Risk|Band|Salesl|Dealer|CID|AType|CValue|LV|HV|DCode|TR|DU|NStartDate|UserRole|WFlag|EOption|PName|NActivationDate|Os|Orig|Cus|OType|ORequired|DType
03|... (10 Replies)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Hi Gurus,
I have a request which needs to pass string into sql.
dummy code as below:
sqlplus -s user/password@instance << EOF >>output.txt
set echo off head off feed off pagesize 0 trimspool on linesize 1000 colsep ,
select emp_no, emp_name from emp
where emp_no in ('a', 'b', 'c');
exit;... (4 Replies)
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Current Situation:
1. Visit: https://xyz.com/2015/september?trackingparam=1234
2. The URL is missing the trailing / after the “september” directory
3. The URL is redirected and rewritten to: https://xyz.com/2015/september/ , dropping the query string data.
Note:... (0 Replies)
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
Hi All,
Thanks for answering my previous question. Could you please explain the highlighted code?
awk -v pos='9 27 39 54 59 64 71 78 83 103 108' 'BEGIN{split(pos,var)} {for (i in var) $0=gensub(/./,"|",var)} 1' test.txt | head
I understood that the split function splits the pos string into... (2 Replies)
Discussion started by: mrcool4
2 Replies
LEARN ABOUT PHP
cubrid_num_fields
CUBRID_NUM_FIELDS(3) 1 CUBRID_NUM_FIELDS(3)cubrid_num_fields - Return the number of columns in the result setSYNOPSIS
int cubrid_num_fields (resource $result)
DESCRIPTION
This function returns the number of columns in the result set, on success, or it returns FALSE on failure.
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3), cubrid_query(3) and cubrid_prepare(3)RETURN VALUES
Number of columns, on success.
-1 if SQL sentence is not SELECT.
FALSE when process is unsuccessful.
EXAMPLES
Example #1
cubrid_num_fields(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$req = cubrid_execute($conn, "SELECT * FROM code");
$row_num = cubrid_num_rows($req);
$col_num = cubrid_num_fields($req);
printf("Row Num: %d
Column Num: %d
", $row_num, $col_num);
cubrid_disconnect($conn);
?>
The above example will output:
Row Num: 6
Column Num: 2
PHP Documentation Group CUBRID_NUM_FIELDS(3)