create sql query Post: 302535180

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

& in SQL query

I have a script that looks for all jobs that contain a particular calendar. Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this? I have tried: select job_name from job where run_calendar='1&15dom' select job_name from job...

2. Shell Programming and Scripting

rsh and sql query

Hi ... I am doing a switch user and then rsh and then running a sql query . I am successfull in rsh and logging into the database , but my query doesnt run .. Here's the command : su - linus -c "rsh -l linus psmf ORACLE_SID=SMP;export ORACLE_SID;sqlplus...

3. UNIX and Linux Applications

SQL Lite query

Hello Everyone, I am looking to write a script that will run on many machines in a network at the same time. They need to write a result to a common location. I plan to use a SQLlite database as this common writing point. But the concern I have is how SQLlite will react to multiple writes that...

4. Shell Programming and Scripting

sql query problem

Hi, I am passing an argument for the script and that argument values should exist in database. bill_period_input="'""$1""'" bill_period=`sqlplus uname/pwd@dbname <<eof! set verify off set heading off set feedback off select bill_period from bill_period_ref where...

5. 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...

6. Shell Programming and Scripting

problem in SQL query

I used the following code code select * from tablename where columnname Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem? Thanks Ananth

7. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

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...

8. Programming

Getting error in sql query

Hi All , I have tried many times am getting syntax error on 'UNION' can anybody tell me ... INSERT INTO table1 ( Type , num_items , num_letters , total_value ) (select type='1', num_items, num_letters=count(*), total_value=sum(letter_value) from table2 where num_items = 1

9. Programming

Help writing SQL query

Hello All, I hope I'm posting this in the right section. I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,...

10. Solaris

SQL QUERY to Table Output

Hi I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p inner join v$session se on p.addr = se.paddr inner join ( select...

LEARN ABOUT DEBIAN

ntfsinfo

NTFSINFO(8)						      System Manager's Manual						       NTFSINFO(8)

NAME

       ntfsinfo - dump a file's attributes

SYNOPSIS

       ntfsinfo [options] device

DESCRIPTION

       ntfsinfo will dump the attributes of inode inode-number or the file path-filename and/or information about the mft ( -m option).  Run ntfs-
       info without arguments for a full list of options.

OPTIONS

       Below is a summary of all the options that ntfsinfo accepts.  Nearly all options have two equivalent names.  The short name is preceded	by
       - and the long name is preceded by --.  Any single letter options, that don't take an argument, can be combined into a single command, e.g.
       -fv is equivalent to -f -v.  Long named options can be abbreviated to any unique prefix of their name.

       -F, --file FILE
	      Show information about this file

       -f, --force
	      This will override some sensible defaults, such as not overwriting an existing file.  Use this option with caution.

       -h, --help
	      Show a list of options with a brief description of each one.

       -i, --inode NUM
	      Show information about this inode.

       -m, --mft
	      Show information about the volume.

       -q, --quiet
	      Produce less output.

       -t, --notime
	      Do not display timestamps in the output.

       -v, --verbose
	      Increase the amount of output that ntfsinfo prints.

       -V, --version
	      Show the version number, copyright and license.

BUGS

       There are no known problems with ntfsinfo.  If you find a bug please send an email describing the problem to the development team:
       ntfs-3g-devel@lists.sf.net

AUTHORS

       ntfsinfo was written by Matthew J. Fanto, Anton Altaparmakov, Richard Russon, Szabolcs Szakacsits, Yuval Fledel, Yura Pakhuchiy	and  Cris-
       tian Klein.  It was ported to ntfs-3g by Erik Larsson and Jean-Pierre Andre.

AVAILABILITY

       ntfsinfo is part of the ntfs-3g package and is available from:
       http://www.tuxera.com/community/

SEE ALSO

       ntfsprogs(8)

ntfs-3g 2012.1.15AR.5						    April 2006							       NTFSINFO(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

& in SQL query

Discussion started by: Lindarella

2. Shell Programming and Scripting

rsh and sql query

Discussion started by: sars

3. UNIX and Linux Applications

SQL Lite query

Discussion started by: garric

4. Shell Programming and Scripting

sql query problem

Discussion started by: ss_ss