UNIX sql options Post: 302843550

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Unix Path Options

I am looking for the best way to move files into a directory (ie PDF_files), if the directory doesn't exist to create it. However I am passing the full filename (psfile) of the file so I will have to remove the filename from the end, which can be at different field end lengths. This is a...

2. Shell Programming and Scripting

unix variables from sql / pl/sql

How do I dynamically assign the below output to unix shell variables so I can build a menu in a shell script? Example: var1 = 1 var2= SYSTEM var3 = 2 var4= UNDOTBS1 and so on, then in the shell script I can use the variables to build a menu. set serveroutput on declare...

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

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

5. UNIX for Dummies Questions & Answers

Unix : About options of clear command ?

Hello everyone, My question is quite simple, even if I didn't find an answer. I would want a command (maybe clear with some options ?) that can do the following : clear completely the console, as it is when we start a console for the first time. My problem is that I sometimes display a lot...

6. UNIX for Dummies Questions & Answers

What are the career options in unix apart from unix system administration?

7. Shell Programming and Scripting

Format options while Redirecting output of sql to a file in shell

In my korn shell - I have a sql with say 6 columns whose output i am redirecting to a file and attaching this file while sending a mail. While all this happens correctly, i face issues in the format of this file. my intended output is Column_1 Column_2 Column_3 Column_4 ...

8. UNIX for Dummies Questions & Answers

UNIX ls options

Hi Guys I'm new to the forums and Unix. I have my first assignment for school and i'm stuck on question 1 spent close to 4 hours on it :(. (doesn't look good). I looked the the online documentation of ls but don't really understand it yet. I need to find files whose names that are of length...

9. Shell Programming and Scripting

UNIX Date function with -d options

Hi , I couldn't understand how this program works. Can somebody please explain it to me. DT=`date -d "1 day"` # This part I understand echo ${DT/ */} # How this works echo ${DT/* /}

LEARN ABOUT MOJAVE

ansi_ctrlu

term::ansi::ctrl::unix(n)					 Terminal control					 term::ansi::ctrl::unix(n)

__________________________________________________________________________________________________________________________________________________

NAME

       term::ansi::ctrl::unix - Control operations and queries

SYNOPSIS

       package require Tcl  8.4

       package require term::ansi::ctrl::unix  ?0.1?

       ::term::ansi::ctrl::unix::import ?ns? ?arg...?

       ::term::ansi::ctrl::unix::raw

       ::term::ansi::ctrl::unix::raw

       ::term::ansi::ctrl::unix::columns

       ::term::ansi::ctrl::unix::rows

_________________________________________________________________

DESCRIPTION

       WARNING:  This  package	is  unix-specific  and depends on the availability of two unix system commands for terminal control, i.e. stty and
       tput, both of which have to be found in the $PATH. If any of these two commands is missing the loading of the package will fail.

       The package provides commands to switch the standard input of the current process between raw and cooked input modes, and to query the size
       of terminals, i.e. the available number of columns and lines.

API

   INTROSPECTION
       ::term::ansi::ctrl::unix::import ?ns? ?arg...?
	      This  command imports some or all attribute commands into the namespace ns. This is by default the namespace ctrl. Note that this is
	      relative namespace name, placing the imported command into a child of the current namespace. By default all commands  are  imported,
	      this can howver be restricted by listing the names of the wanted commands after the namespace argument.

   OPERATIONS
       ::term::ansi::ctrl::unix::raw
	      This command switches the standard input of the current process to raw input mode. This means that from then on all characters typed
	      by the user are immediately reported to the application instead of waiting in the OS buffer until the Enter/Return key is received.

       ::term::ansi::ctrl::unix::raw
	      This command switches the standard input of the current process to cooked input mode. This means that from then  on  all	characters
	      typed by the user are kept in OS buffers for editing until the Enter/Return key is received.

       ::term::ansi::ctrl::unix::columns
	      This command queries the terminal connected to the standard input for the number of columns available for display.

       ::term::ansi::ctrl::unix::rows
	      This command queries the terminal connected to the standard input for the number of rows (aka lines) available for display.

BUGS, IDEAS, FEEDBACK
       This  document, and the package it describes, will undoubtedly contain bugs and other problems.	Please report such in the category term of
       the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you  may  have  for
       either package and/or documentation.

KEYWORDS

       ansi, columns, control, cooked, input mode, lines, raw, rows, terminal

CATEGORY

       Terminal control

COPYRIGHT

       Copyright (c) 2006 Andreas Kupries <andreas_kupries@users.sourceforge.net>

term									0.1						 term::ansi::ctrl::unix(n)