01-15-2016
If it was me, I would do "where TRUNC(date_col, 'MM') = '1-APR-2005' ". That way you only need to pass in one date. Also if you use Oracle you can create a function based index on TRUNC(date_col) if you want. You then don't need to know the last day of the month. Another way to do that is to add a month to the first of the month and subtract a day. "ADD_MONTH('1-APR-2005', 1)-1 ". still you only need to pass in one date and will get a range scan if you have that column as the leading edge of an index.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time.
## Accept variable(s) from the command line... (1 Reply)
Discussion started by: jagannatha
1 Replies
2. Shell Programming and Scripting
Hi all, I have a shell script which invoke a sql script using command
db2 -tf /home/me/db_housekeep.sql -z /home/me/db_housekeep.log
however, this mentioned sql script requires several input arguments, I wonder if one can pass variables from shell script to sql script? thanks! (0 Replies)
Discussion started by: mpang_
0 Replies
3. Shell Programming and Scripting
Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies
4. Shell Programming and Scripting
Hi Guys,
I like to pass a variable to a sql file in a unix script..
I tried a below code..
var=200903
db2 -vf test.sql 200903
test.sql is as below.
select * from db2.users where quarter = $1;
Please tell me where i go wrong..
Thanks in advance,
Magesh (2 Replies)
Discussion started by: mac4rfree
2 Replies
5. UNIX for Advanced & Expert Users
Hi,
I am unable to use parameter in sql script passed from unix script.
my sql script CREATE_SBI_LIST_GROUP.sql is like this -
-------------------------------
SELECT
SDS.ID "SO_ID",
SDS.SO a1,
sgp.sga__code SGA_CODE,
FROM
sga sga,sales_genl_provision sgp , comm_product_condn cpc... (2 Replies)
Discussion started by: apskaushik
2 Replies
6. Shell Programming and Scripting
Hi Guys,
Can someone please help me on adding/inserting a variable date to an sql scipt? Basically I want to assign a 7 days date range. As shown below..
#!/usr/bin/perl
use strict;
use Env qw(ORACLE_HOME);
my $SQLPLUS='/opt/oracle/product/10.1.0/db_1/bin/sqlplus -S... (1 Reply)
Discussion started by: pinpe
1 Replies
7. Shell Programming and Scripting
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies
8. Shell Programming and Scripting
Hello,
i`m looking for some way to add to some date an partial number of months, for example to 2015y 02m 27d + 2,54m
i need to write this script in php or bash or sh or mysql or perl in normal time o unix time
i`m asking or there are any simple way to add partial number of month to some... (14 Replies)
Discussion started by: bacarrdy
14 Replies
9. Shell Programming and Scripting
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Discussion started by: a1_win
7 Replies
10. Shell Programming and Scripting
Hi All,
I am new to shell script. I am trying to pass value from .sh file to .sql file .
But I am able to run the .sql file from .sh file with values in sql file.
But I am unable to pass the values from .sh file. can some one please help to resolve this.
here is my .sh file
s1.sh
... (4 Replies)
Discussion started by: reddy298599
4 Replies
LEARN ABOUT DEBIAN
px_timestamp2string
PX_TIMESTAMP2STRING(3) Library Functions Manual PX_TIMESTAMP2STRING(3)
NAME
PX_timestamp2string -- Convert paradox timestamp into formated string
SYNOPSIS
#include <paradox.h>
char * PX_timestamp2string(pxdoc_t *pxdoc, double timestamp, const char *format)
DESCRIPTION
Creates a string representation of a paradox timestamp as specified in the parameter format. The timestamp must be either retrieved with
PX_get_data_double(3) after calling PX_get_record(3) or by simply using the double value in the pxval_t struct as returned by
PX_retrieve_record(3). A timestamp contains both time and date information. The format string contains chars which stand for certain values
of the date/time. The following table lists all available characters with a meaning. All other characters are being copied unmodified to
the output string. If a special character shall not be interpreted it must be preceded with a backslash.
Characters and their meaning in date/time format string
Character Meaning
Y year, numeric, 4 digits
y year, numeric, 2 digits
m month, numeric
n month, numeric, no leading zeroes
d day of the month, numeric
j T{
day of the month, numeric, no leading zeros
T}
H hour, numeric, 24 hour format
h hour, numeric, 12 hour format
G T{
hour, numeric, 24 hour format, no leading zeroes
T}
g T{
hour, numeric, 12 hour format, no leading zeroes
T}
i minutes, numeric
s seconds, numeric
A AM/PM
a am/pm
L boolean for leap year
RETURN VALUE
Returns pointer to string on success and NULL on failure.
SEE ALSO
PX_time2string(3), PX_date2string(3)
AUTHOR
This manual page was written by Uwe Steinmann uwe@steinmann.cx.
PX_TIMESTAMP2STRING(3)