Sponsored Content
Full Discussion: Trouble with external tables
Top Forums Shell Programming and Scripting Trouble with external tables Post 302561125 by radoulov on Monday 3rd of October 2011 08:11:03 AM
Old 10-03-2011
An example using the dual table just for demonstration:

Code:
printf 'select %s from dual;' "$(
  printf "'%s'\n" $(<infile) |
    paste -sd, -
    )" |
      sqlplus -S '/ as sysdba'

The output is:

Code:
$ cat infile
AT & T
CITIZENS MOHAVE CELLULAR
COMMNET
DRR
E1CELLULAR
$ printf 'select %s from dual;' "$(
>   printf "'%s'\n" $(<infile) |
>     paste -sd, -
> )" |
>   sqlplus -S '/ as sysdba'

'A ' ' 'CITIZEN 'MOHAV 'CELLULA 'COMMNE 'DR 'E1CELLULA
-- - - -------- ------ -------- ------- --- ----------
AT & T CITIZENS MOHAVE CELLULAR COMMNET DRR E1CELLULAR


So, if I understand the requirement correctly, you'll need something like this:

Code:
printf 'SELECT MO_IDENTIFER, SERVICE_PROVIDER 
        FROM MVNO_SP WHERE SERVICE_PROVIDER IN (%s);' "$(
  printf "'%s'\n" $(<infile) |
    paste -sd, -
    )" |
      sqlplus -S <connect_string>

 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

viewing tables

I have completely blanked out on this and I have done it a million times. I need to modify some tables in unix. What is the command for opening/viewing the tables? Thanks so much. :o (2 Replies)
Discussion started by: itldp
2 Replies

2. UNIX for Dummies Questions & Answers

Routing tables

Hey guys, I needed to add a route to my routing table and I got it to work but on reboot it gets removed. Anyone know what file I can add this route to so it stays on the machine after a reboot? (9 Replies)
Discussion started by: kingdbag
9 Replies

3. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies

4. Shell Programming and Scripting

Tables and borders

when i do this: cat HITS i get the following displayed: sport.hits:87.114.172.31 Thu Sep 28 22:45:12 GMT 2006 how do i put this information into a bordered table? so it will output like this: ...........File /... (9 Replies)
Discussion started by: amatuer_lee_3
9 Replies

5. Shell Programming and Scripting

Display tables of 6

I'm new to linux and unix I would like to know how to display tables of 6 line after line Output should be 1*6 = 6 2*6 = 12 3*6 = 18 4*6 = 24 etc I can display line by line but not continuously Any suggestion (3 Replies)
Discussion started by: electricair
3 Replies

6. UNIX for Dummies Questions & Answers

Mysqldump certain tables

Hi, I have to upload part of my database periodically when i make changes to product data etc. However I only want to upload certain tables. We suffer from bandwidth chock here, so i want to write a couple of separate scripts that upload parts of the database that changed. The database is large... (5 Replies)
Discussion started by: timgolding
5 Replies

7. Programming

C++ Dictionaries and tables

I was looking at this code from a programming book: #include <time.h> #include <iostream> #include <string> #include <deque> #include <map> #include <vector> #include <cstdlib> using namespace std; const int NPREF = 2; const char NONWORD = "\n"; // cannot appear as real line: we... (1 Reply)
Discussion started by: totoro125
1 Replies

8. Shell Programming and Scripting

Compare with 2 tables

I have 3 file inputs, file1 20160302|5485368299953|96|510101223440252|USA|5485368299953|6|800|2300|0 20160530|5481379883742|7|510101242850814|USA|5481379883742|5|540|2181|1500 20160513|5481279653404|24|510100412142433|INDIA|5481279653404|3|380|1900|0... (1 Reply)
Discussion started by: radius
1 Replies

9. Programming

How to arhive hive external tables?

Hi Guys, Is there a way to check hive external tables which are created 90 days before and drop those tables along with underlying hdfs data. Can this be achieved in unix script? (10 Replies)
Discussion started by: Master_Mind
10 Replies
GLPROVOKINGVERTEX(3G)						    OpenGL 3.3						     GLPROVOKINGVERTEX(3G)

NAME
glProvokingVertex - specifiy the vertex to be used as the source of data for flat shaded varyings C SPECIFICATION
void glProvokingVertex(GLenum provokeMode); PARAMETERS
provokeMode Specifies the vertex to be used as the source of data for flat shaded varyings. DESCRIPTION
Flatshading a vertex shader varying output means to assign all vetices of the primitive the same value for that output. The vertex from which these values is derived is known as the provoking vertex and glProvokingVertex specifies which vertex is to be used as the source of data for flat shaded varyings. provokeMode must be either GL_FIRST_VERTEX_CONVENTION or GL_LAST_VERTEX_CONVENTION, and controls the selection of the vertex whose values are assigned to flatshaded varying outputs. The interpretation of these values for the supported primitive types is: If a vertex or geometry shader is active, user-defined varying outputs may be flatshaded by using the flat qualifier when declaring the output. NOTES
glProvokingVertex is available only if the GL version is 3.2 or greater. ERRORS
GL_INVALID_ENUM is generated if provokeMode is not an accepted value. COPYRIGHT
Copyright (C) 2010 Khronos Group. This material may be distributed subject to the terms and conditions set forth in the Open Publication License, v 1.0, 8 June 1999. http://opencontent.org/openpub/. OpenGL 3.3 03/08/2011 GLPROVOKINGVERTEX(3G)
All times are GMT -4. The time now is 05:21 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy