Sponsored Content
Full Discussion: SQL Commands in Unix
Top Forums Shell Programming and Scripting SQL Commands in Unix Post 302074082 by sish78 on Friday 19th of May 2006 01:57:46 PM
Old 05-19-2006
SQL Commands in Unix

Hi gurus,

Being a newbie not sure whether iam asking the right question?

can we use oracle commands in unix for ex: to read a count on a table.

if so, what needs to be configured and etc..

any kind of help is appreciated.

Thanks
sish
 

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to sql commands in shell script

hi, plz let me know one example in using sql command in shell script thanks inadvance -bali. (1 Reply)
Discussion started by: balireddy_77
1 Replies

2. AIX

how can i install sqlplus and execute some sql commands

hi everybody, i am Talip, a begginner at unix based systems and i have a problem (actually, we may think myself as the problem, in this situation). i am not sure if this is the correct platform for my questions. if it is not please forgive me about this inappropriate mail. what i have: *... (2 Replies)
Discussion started by: talipk
2 Replies

3. Shell Programming and Scripting

SQL commands in a shell scripting

Hi, I need to write a shell script file that does 1)Connects to DB using SQL plus 2)Do some SQL query like select * from.... 3)Based on the output that I got from the sql query I will have to write a if else loop. Plz let me know how to write the shell scripting for this. Thanks for... (1 Reply)
Discussion started by: villain41
1 Replies

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

5. Shell Programming and Scripting

SQL commands in Scripting

Hi , Daily I sneding report to client about the status of State 2 jobs in Control M . I would like to schedule it via cron . I am using teh following command : sudo su - <control M server Name> then reach to the control M server then run #isql <It ask for the password > ... (1 Reply)
Discussion started by: chandancsc
1 Replies

6. UNIX Desktop Questions & Answers

Multiple SQL Commands

Hello Experts !!! Im new to this so, please bear with me ! I have the following 2 sql statements create table CMD_NEW_USER as Select FD.EMPLOYEE, FD.PASTUSER, ..... FROM REPORTS FS, TASKLIST FD WHERE FS.EMPLOYEEID = FD.EMPLOYEEID ; create table CMD_OLD_USER as Select FD.EMPLOYEE,... (4 Replies)
Discussion started by: OMLEELA
4 Replies

7. Shell Programming and Scripting

script to parse text file into sql commands

Hello all, I tried searching for something similiar before posting but couldn't come up with anything that fit what I need. In Linux, I'm trying to parse through a number of files and take the info in them and put it into mysql. My file is a dump from an expect script: ---filename... (3 Replies)
Discussion started by: hamanjam
3 Replies
Handles(3tclx)															    Handles(3tclx)

NAME
Tcl_HandleAlloc, Tcl_HandleFree, Tcl_HandleTblInit, Tcl_HandleTblRelease, Tcl_HandleTblUseCount, Tcl_HandleWalk, Tcl_HandleXlate - Dynamic, handle addressable tables. SYNOPSIS
#include <tclExtend.h> void_pt Tcl_HandleTblInit (const char *handleBase, int entrySize, int initEntries); int Tcl_HandleTblUseCount (void_pt headerPtr, int amount); void Tcl_HandleTblRelease (void_pt headerPtr); void_pt Tcl_HandleAlloc (void_pt headerPtr, char *handlePtr); void_pt Tcl_HandleXlate (Tcl_Interp *interp, void_pt headerPtr, const char *handle); void_pt Tcl_HandleWalk (void_pt headerPtr, int *walkKeyPtr); void Tcl_WalkKeyToHandle (void_pt headerPtr, int walkKey, char *handlePtr); void Tcl_HandleFree (void_pt headerPtr, void_pt entryPtr); DESCRIPTION
The Tcl handle facility provides a way to manage table entries that may be referenced by a textual handle from Tcl code. This is provided for applications that need to create data structures in one command, return a reference (i.e. pointer) to that particular data structure and then access that data structure in other commands. An example application is file handles. A handle consists of a base name, which is some unique, meaningful name, such as `file' and a numeric value appended to the base name (e.g. `file3'). The handle facility is designed to provide a standard mechanism for building Tcl commands that allocate and access table entries based on an entry index. The tables are expanded when needed, consequently pointers to entries should not be kept, as they will become invalid when the table is expanded. If the table entries are large or pointers must be kept to the entries, then the the entries should be allocated separately and pointers kept in the handle table. A use count is kept on the table. This use count is intended to determine when a table shared by multiple commands is to be release. Tcl_HandleTblInit Create and initialize a Tcl dynamic handle table. The use count on the table is set to one. Parameters: o handleBase - The base name of the handle, the handle will be returned in the form "baseNN", where NN is the table entry number. o entrySize - The size of an entry, in bytes. o initEntries - Initial size of the table, in entries. Returns: A pointer to the table header. Tcl_HandleTblUseCount Alter the handle table use count by the specified amount, which can be positive or negative. Amount may be zero to retrieve the use count. Parameters: o headerPtr - Pointer to the table header. o amount - The amount to alter the use count by. Returns: The resulting use count. Tcl_HandleTblRelease Decrement the use count on a Tcl dynamic handle table. If the count goes to zero or negative, then release the table. Parameters: o headerPtr - Pointer to the table header. Tcl_HandleAlloc Allocate an entry and associate a handle with it. Parameters: o headerPtr - A pointer to the table header. o handlePtr - Buffer to return handle in. It must be big enough to hold the name. Returns: A pointer to the allocated entry (user part). Tcl_HandleXlate Translate a handle to a entry pointer. Parameters: o interp - A error message may be returned in result. o headerPtr - A pointer to the table header. o handle - The handle assigned to the entry. Returns: A pointer to the entry, or NULL if an error occurred. Tcl_HandleWalk Walk through and find every allocated entry in a table. Entries may be deallocated during a walk, but should not be allocated. Parameters: o headerPtr - A pointer to the table header. o walkKeyPtr - Pointer to a variable to use to keep track of the place in the table. The variable should be initialized to -1 before the first call. Returns: A pointer to the next allocated entry, or NULL if there are not more. Tcl_WalkKeyToHandle Convert a walk key, as returned from a call to Tcl_HandleWalk into a handle. The Tcl_HandleWalk must have succeeded. Parameters: o headerPtr - A pointer to the table header. o walkKey - The walk key. o handlePtr - Buffer to return handle in. It must be big enough to hold the name. Tcl_HandleFree Frees a handle table entry. Parameters: o headerPtr - A pointer to the table header. o entryPtr - Entry to free. Tcl Handles(3tclx)
All times are GMT -4. The time now is 08:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy