Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to get value from a close and open parenthesis?
Top Forums Shell Programming and Scripting How to get value from a close and open parenthesis? Post 302997760 by ernesto on Friday 19th of May 2017 04:59:55 AM
Old 05-19-2017
How to get value from a close and open parenthesis?
Hi Gurus,

I have an input like the one below. What i wanted to achieved is to create a select statement based from that information

INPUT
Code:
Insert into table_name (col1,col2,col3,col4,col5,DATE1,DATE2,col6,col7,col8,col9,col10,col11) values (6752,14932156,24,'ALL','Staff',to_date('04/17/2017 00:00:00','MM/DD/YYYY HH24:MI:SS'),to_date('05/24/2017 23:59:59','MM/DD/YYYY HH24:MI:SS'),'aso 4','device',148,null,null,null);

OUTPUT
Code:
SELECT * FROM table_name 
WHERE col1   = 6752
AND   col2   = 14932156
AND   col3   = 24
AND   col4   = 'ALL'
AND   col5   = 'Staff'
AND   DATE1  = to_date('04/17/2017 00:00:00','MM/DD/YYYY HH24:MI:SS')
AND   DATE2  = to_date('05/24/2017 23:59:59','MM/DD/YYYY HH24:MI:SS')
AND   col6   = 'aso 4'
AND   col7   = 'device'
AND   col8   = 148
AND   col9   is null
AND   col10  is null
AND   col11  is null;

need your inputs on this.

Thanks.
Last edited by rbatte1; 05-19-2017 at 07:35 AM.. Reason: Reverted to supplied as I had missed the point.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

File status - open/close ??

Is there any commands in UNIX, like isopen(),isclose() to know whether a file has been opened for read/write purpose.? Thanks (3 Replies)
Discussion started by: Pal
3 Replies

2. UNIX for Dummies Questions & Answers

Should a UNIX daemon process close open fds?

I have a UNIX daemon process that's been started by a parent process, an application server. The behavior of this daemon process is to inherit and use the app server's file descriptors (ports/sockets). When I shutdown the app server, the daemon continues to run, because there may be other... (1 Reply)
Discussion started by: kunalashar
1 Replies

3. Solaris

close open files before remove

Hi I have a script to remove log files when it reaches %70 usage in order to descending order of dates. But sometimes it happens to remove open - being processes files , so makes them unlinked from the directors and results them disappeared. How can I solve this problem , simple scenario I... (9 Replies)
Discussion started by: xramm
9 Replies

4. UNIX for Advanced & Expert Users

Number of open files (Dir's) how to close?

I am having a client/server application which will download files from server. If server has directories, it will create directories/sub directories and then download files. In this process, I observed that number of open files are more than 400 (which is approxmately same as number of dir/subdir... (1 Reply)
Discussion started by: satyam90
1 Replies

5. Windows & DOS: Issues & Discussions

Can DOS close an open file?

I'm trying to setup a cron job for my brother that goes out to the web and retrieves an excel file and overwrites the existing copy on his desktop. The problem I'm facing is I have to kill the process (excel.exe) if the file is open while the batch file runs, otherwise, it will create another copy... (2 Replies)
Discussion started by: quattro20v
2 Replies

6. Solaris

file open/read/write/close/access by process

Hi want to know what file (descriptor+filename+socket) is being accessed by particular process on solaris. Purpose : while running perf. test, needs to find where is the bottleneck. We are providing concurrnet load for around 1 hr and needs to capture data related to file usage pattern... (1 Reply)
Discussion started by: raxitsheth
1 Replies

7. Shell Programming and Scripting

Cleanup between parenthesis

Hi, I am trying to clean up data between parenthesis () in a file. See example below.... Input File : (New York) Chicago (London) New York (Chicago) London New York Chicago (London) (New York) (Chicago) (London) New York (Chicago) ... (3 Replies)
Discussion started by: msalam65
3 Replies

8. Programming

when parent process close, how to close the child?

can someone provide an example, where if the parent process quits for any reason, then the child process will also close? (3 Replies)
Discussion started by: omega666
3 Replies

9. IP Networking

Open/close of ports

Hi, I have read some forum theads about the open and close ports. some points are clear and it is not working on my machine or something am i missing? I have commented out a port /etc/services, one application uses then when i use the telnet <hostname> <port_blocked> it shows connected..... (1 Reply)
Discussion started by: balamv
1 Replies

10. Shell Programming and Scripting

Work with setsid to open a session and close it correctly

I would like to create the following script: run a python script with setsid python may or may not fail with exception check if all of the group processes were terminated correctly if not, kill the remaining processes How can I do that? Thanks a lot (3 Replies)
Discussion started by: ASF Studio
3 Replies

LEARN ABOUT DEBIAN

data::formvalidator::constraints::dates

Data::FormValidator::Constraints::Dates(3pm)		User Contributed Perl Documentation	      Data::FormValidator::Constraints::Dates(3pm)

NAME

       Data::FormValidator::Constraints::Dates - Validate Dates and Times

SYNOPSIS

	   use Data::FormValidator::Constraints::Dates qw(date_and_time);

	   # In a DFV profile...
	   constraint_methods => {
	       # 'pp' denotes AM|PM for 12 hour representation
	       my_time_field => date_and_time('MM/DD/YYYY hh:mm:ss pp'),
	   }

DESCRIPTION

   date_and_time
       Note: This is a new module is a new addition to Data::FormValidator and is should be considered "Beta".

       This constraint creates a regular expression based on the format string passed in to validate your date against. It understands the
       following symbols:

	   Y   year  (numeric)
	   M   month (numeric)
	   D   day   (numeric)
	   h   hour
	   m   minute
	   s   second
	   p   AM|PM

       Other parts of the string become part of the regular expression, so you can do perlish things like this to create more complex expressions:

	   'MM?/DD?/YYYY|YYYY-MM?-DD?'

       Internally Date::Calc is used to test the functions.

BACKWARDS COMPATIBILITY

       This older, more awkward interface is supported:

	   # In a Data::FormValidator Profile:
	   validator_packages => [qw(Data::FormValidator::Constraints::Dates)],
	   constraints => {
	       date_and_time_field	 => {
		   constraint_method => 'date_and_time',
		   params=>['MM/DD/YYYY hh:mm:ss pp'], # 'pp' denotes AM|PM for 12 hour representation
	       },
	   }

SEE ALSO

       o   Data::FormValidator

       o   Data::FormValidator::Constraints::DateTime  - This alternative features returning dates as DateTime objects and validating against the
	   date formats required for the MySQL and PostgreSQL databases.

AUTHOR

       Mark Stosberg, <mark@summersault.com>

       Featuring clever code by Jan Krynicky.

COPYRIGHT AND LICENSE

       Copyright 2003-2005 by Mark Stosberg

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2011-11-25			      Data::FormValidator::Constraints::Dates(3pm)
All times are GMT -4. The time now is 05:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy