Sponsored Content
Top Forums Shell Programming and Scripting Extracting Table names from a Select Stament Post 302171658 by kulbir on Friday 29th of February 2008 06:31:30 AM
Old 02-29-2008
hey hi

i didint got urs question correctly....! man

u want sql statement

fine then u can give it as

select * from all_tabs_colums where table_name ="name of the table";

sum thing like


varible name =`sqlplus -s "id"/"password" << END

set serveroutput on
select * from all_tabs_colums where table_name ="name of the table";

end'
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extracting select queries from script

Hi, I have a script in which a lot of sql queries are embedded ie,"Select .....;".My purpose is to document all the dml statements in the script along with the line number. I am thinking of writing a perlscript or by using awk/sed scripts for extracting all the 'select' statements/queries... (3 Replies)
Discussion started by: DILEEP410
3 Replies

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

3. UNIX for Dummies Questions & Answers

Extracting all table names from a given server

Using ksh and sqlplus... does anybody have an idea of how we can possibly extract all table names from server :confused:? thanks in advance. (6 Replies)
Discussion started by: fmina
6 Replies

4. UNIX for Dummies Questions & Answers

How to select only those file names whose name contains only numbers.

Hi Guru's, Before writing to this forum I have searched extensively on this forum about my problem. I have to write a shell script which takes out only those file names from the given directory which contains only numbers. For example, In the given directory these files are present: ... (0 Replies)
Discussion started by: spranm
0 Replies

5. UNIX for Advanced & Expert Users

How to select only those file names whose name contains only numbers

Hi Guru's, Before writing to this forum I have searched extensively on this forum about my problem. I have to write a shell script which takes out only those file names from the given directory which contains only numbers. For example, In the given directory these files are present: ... (4 Replies)
Discussion started by: spranm
4 Replies

6. Shell Programming and Scripting

How to select only those file names whose name contains only numerals.

Hi Guru's, Before writing to this forum I have searched extensively on this forum about my problem. I have to write a shell script which takes out only those file names from the given directory which contains only numbers. For example, In the given directory these files are present: ... (5 Replies)
Discussion started by: spranm
5 Replies

7. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

8. Shell Programming and Scripting

mysql how to select a specific row from a table

i have a table records ------------ id | user | time | event 91 admin | 12:00 | hi 92 admin | 11:00 | hi 93 admin | 12:00 | bye 94 admin | 13:00 | bye 95 root | 12:00 | hi 96 root | 12:30 | hi 97 root | 12:56 | hi how could i only select and display only the user and event from... (6 Replies)
Discussion started by: kpddong
6 Replies

9. Shell Programming and Scripting

Select table name from file

i have a file tabel.out which contain table name in this format. xyz abc qwe Plz help me writing one script which actually takes tablename from file table.out file one by one and then select count (*) from $tablename limit 10; and print error in output file if any tabel is not... (4 Replies)
Discussion started by: netdbaind
4 Replies

10. Programming

Query to SELECT only Column Names that Contain a Specific String?

Hey Guys, I'm using SQuirreL SQL v3.5 GUI to fetch some data that I need for something I'm working on. I'm also using the IBM Informix Driver (*Version 3.5) to connect to the Database. What I want to do, if it's even possible, is to show all COLUMNS if they contain the word "Email". So in... (2 Replies)
Discussion started by: mrm5102
2 Replies
OVRIMOS_FETCH_INTO(3)													     OVRIMOS_FETCH_INTO(3)

ovrimos_fetch_into - Fetches a row from the result set

SYNOPSIS
bool ovrimos_fetch_into (int $result_id, array &$result_array, [string $how], [int $rownumber]) DESCRIPTION
Fetches a row from the given result set, into $result_array. PARAMETERS
o $result_id - A result identifier, returned by ovrimos_execute(3) or ovrimos_exec(3). o $result_array - You must provide an array by reference. It will be filled with the fetched values. o $how - Determines how the rows are fetched. This can be one of the following strings (case is not significant): +---------+---------------------------------------------------+ | Option | | | | | | | Notes | | | | +---------+---------------------------------------------------+ | | | | Next | | | | | | | Forward direction from current position. This is | | | the default value. | | | | | | | | Prev | | | | | | | Backward direction from current position. | | | | | | | | First | | | | | | | Forward direction from the start. | | | | | | | | Last | | | | | | | Backward direction from the end. | | | | | | | |Absolute | | | | | | | Absolute position from the start. Requires | | | $rownumber. | | | | +---------+---------------------------------------------------+ o $rownumber - The row number, first one is 0. Only needed when $how is set to Absolute. RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 A fetch into example <?php $conn=ovrimos_connect("neptune", "8001", "admin", "password"); if ($conn!=0) { echo "Connection ok!"; $res=ovrimos_exec($conn, "select table_id, table_name from sys.tables"); if ($res != 0) { echo "Statement ok!"; if (ovrimos_fetch_into($res, $row)) { list($table_id, $table_name) = $row; echo "table_id=" . $table_id . ", table_name=" . $table_name . " "; if (ovrimos_fetch_into($res, $row)) { list($table_id, $table_name) = $row; echo "table_id=" . $table_id . ", table_name=" . $table_name . " "; } else { echo "Next: error "; } } else { echo "First: error "; } ovrimos_free_result($res); } ovrimos_close($conn); } ?> SEE ALSO
ovrimos_fetch_row(3). PHP Documentation Group OVRIMOS_FETCH_INTO(3)
All times are GMT -4. The time now is 04:24 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy