Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: how to find all .sql file names in all .sh unix files
Top Forums UNIX for Dummies Questions & Answers how to find all .sql file names in all .sh unix files Post 302618459 by CarloM on Wednesday 4th of April 2012 04:34:10 AM
Old 04-04-2012
Code:
find . -name "*.sh" | xargs grep -l "\.sql"

(replace . with whatever path you want to start searching from)
These 2 Users Gave Thanks to CarloM For This Post:
lakshmanrk811 rajesh4you
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Extracting column names from a table.. SQL with UNIX

:rolleyes: hi there everybody, i need help,... thanks anyway! i am working on a very huge table with the name table1. the problem is that i know only one field name in this table..., working with a ksh environment i don't know how to view the table to check out the field names :confused:. ... (4 Replies)
Discussion started by: fmina
4 Replies

2. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies

3. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

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)
Discussion started by: Nareshp
2 Replies

4. Shell Programming and Scripting

How to find complete file names in UNIX if i know only extention of file

Suppose I have a file which contains other file names with some extention . text file containt gdsds sd8ef g/f/temp_temp.sum yyeta t/unix.sum ghfp hrwer h/y/test.text.dat if then.... I want to get the complete file names, like for above file I should get output as temp_temp.sum... (4 Replies)
Discussion started by: panchal
4 Replies

5. Shell Programming and Scripting

How to find empty files in a directory and write their file names in a text?

I need to find empty files in a directory and write them into a text file. Directory will contain old files as well, i need to get the empty files for the last one hour only. (1 Reply)
Discussion started by: vel4ever
1 Replies

6. Shell Programming and Scripting

How to find all files which has names in uppercase in a directory

i want to display all the files which has their names in the Uppercase in a particular directory...guide.. (6 Replies)
Discussion started by: sheelsadan
6 Replies

7. UNIX for Dummies Questions & Answers

Hot to retrieve *.sql file names which we refer in .sh file.

Hi Guys, How to retrieve/get *.sql file names which we refer in all *.sh files. Can any one help me on this. Thanks, Kolipaka (3 Replies)
Discussion started by: lakshmanrk811
3 Replies

8. Shell Programming and Scripting

How to find files without any name i.e. blank names???

I tried using find . -type f -name " " It works only if there is single space. what if i want to find only for the files without any name(no space constraint)??? (12 Replies)
Discussion started by: nikhil jain
12 Replies

9. Shell Programming and Scripting

Exclude certain file names while selectingData files coming in different names in a file name called

Data files coming in different names in a file name called process.txt. 1. shipments_yyyymmdd.gz 2 Order_yyyymmdd.gz 3. Invoice_yyyymmdd.gz 4. globalorder_yyyymmdd.gz The process needs to discard all the below files and only process two of the 4 file names available ... (1 Reply)
Discussion started by: dsravanam
1 Replies

10. Shell Programming and Scripting

Need script to pass all sql file names in a directory to DB query

Hi All, In this path /home/all_files we have follwing files and direcotries proc_edf_sot.sql proc_ssc_sot.sql func_dfg_sot.sql sot unic cmr sdc under sot directory we have other directories sql pas ref under sql directory we have sql_sot sql_mat (6 Replies)
Discussion started by: ROCK_PLSQL
6 Replies

LEARN ABOUT DEBIAN

oarnodesetting

oarnodesetting(1)						   OAR commands 						 oarnodesetting(1)

NAME

       oarnodesetting - Change the state and properties of a node in OAR.

SYNOPSIS

       oarnodesetting [-h hostname | [[-r resource_number][--sql "sql syntax"] | -a]]

DESCRIPTION

       This command is used to Change the state and properties of a node in OAR.

OPTIONS

       -a, --add
	   Add a new resource.

       -s, --state STATE
	   Set the new state of the node. The available states are: Alive, Absent and Dead.

       -m, --maintenance on/off
	   Set the maintenance mode on/off (resource state will be set to absent and available_upto field set to 0).

       -h, --hostname HOSTNAME
	   Set the node hostname.

       -r, --resource
	   Set the resource.

       --sql
	   Get resource identifiers which respond to the SQL where clause on the table jobs (ex: "type = 'default'").

       -p, --property "PROPERTY=VALUE"
	   Set the property of the node to the given value.

       -n, --nowait
	   Do not wait for job ends when the node switches to Absent or Dead.

EXAMPLES

       oarnodesetting -s Alive -h node012
       oarnodesetting -s Absent -h node012

COPYRIGHTS

	Copyright 2003-2012 LIG http://lig.imag.fr This software is licensed under the GNU General Public License Version 2 or above. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

oarnodesetting							    2012-05-23							 oarnodesetting(1)
All times are GMT -4. The time now is 04:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy