Oracle Select IN statement

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Storing passing and executing select statement in loop

Hi, i want to do the following: Grep the following kind of strings for the 15digit ID which is stored in filename1: "14:06:51.396 INFO BMCREMEDYSD INPUT-ACTION Failed to retrieve Remedy Incident Modification record: 000000000039047 org.apache.axis2.AxisFault: Read timed out - complete...

2. Shell Programming and Scripting

SQLPLUS command with more than 1 select statement

Hi all, I'm using below code processId=`sqlplus -s ${sysuser}/${syspwd} <<CHK_PROCESS whenever sqlerror exit sql.sqlcode; set head off feedback off echo off pages 0 SELECT PROCESS_ID FROM LSHADMIN.DATA_DOMAIN WHERE DOMAIN_NAME = '${tabname}' ...

3. Shell Programming and Scripting

Parse SQL text and only format first SELECT statement.

Hi Forum. Need your expertise on the following question. I have the following file which I would like to parse, find first block of SELECT statment and concatenate all input fields as 1 field (~ delimited): Old File: SELECT /*+ USE_HASH(CCOMM ICAR IMAP IAS IP IMAS IMPS IAP SPCA) */ ...

4. Shell Programming and Scripting

Problem with select statement

Hi I have run out of ideas as to why this select doesn't work in a script I am writing. The script sources a file of common functions and I am trying to use a select statement within one of the functions - PS3="Try? " select X in CONT EXIT; do if ] ...

5. Shell Programming and Scripting

for each value in an array, execute select statement

Hello All, I am new to shell scripting. I am working on Solaris O/S, bash script and sybase programming. I want to loop through multiple values in an array and for each value, I want to select a row from the database. following is the code written for it. output="loop.csv" ...

6. Shell Programming and Scripting

Select variable within a if statement

i want to select a variable created and use it in a if statement, but not getting the desired results LINE='device for 0101a01: lpd://172.25.41.111:515' prt=`echo $LINE | awk '{print $3 }' | cut -c 1-7` echo $prt My if statement to select just what i want.. IFS=$":" while read prt...

7. Shell Programming and Scripting

perl DBI: populate a scalar from a select statement

hi every resource i see regarding DBI refers to retrieving data from a database into and array or a hash, but i havent seen anything on how to pull out a single value to a scalar in my database i have a field called "forcewrite" with a value of "6". I am trying to connect to the database,...

8. Shell Programming and Scripting

How can i assign an select statement into a variable?

I am trying to assign an select statement into a variable. Can someone hel me with this. example : a='select * from dual' echo $a should give me select * from dual But this is not working. I trying with \ before * and quotes too.

9. Shell Programming and Scripting

using SELECT sql statement in shell script

Hi there I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this SN=123456 n=server1 m=x4140 sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';" echo $sql |/usr/sfw/bin/mysql -h...

10. Windows & DOS: Issues & Discussions

Want to use the output of Select statement in Unix script

Hi, I have a UNIX script which calls SQL Select statement: Now i want to use the output of that select statement within my UNIX script so as to call different shell script depending upon the output of the select statement. Can anyone help me in this regard. TIA Akhil Goel

LEARN ABOUT REDHAT

create_table_as

CREATE TABLE 
AS(7)						   SQL Commands 						CREATE TABLE AS(7)

NAME

       CREATE TABLE AS - create a new table from the results of a query

SYNOPSIS

       CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ]
	   AS query

DESCRIPTION

       CREATE  TABLE AS creates a table and fills it with data computed by a SELECT command. The table columns have the names and data types asso-
       ciated with the output columns of the SELECT (except that you can override the column names by  giving  an  explicit  list  of  new  column
       names).

       CREATE TABLE AS bears some resemblance to creating a view, but it is really quite different: it creates a new table and evaluates the query
       just once to fill the new table initially. The new table will not track subsequent changes to the source tables of the query. In  contrast,
       a view re-evaluates its defining SELECT statement whenever it is queried.

PARAMETERS

       [LOCAL] TEMPORARY or [LOCAL] TEMP
	      If specified, the table is created as a temporary table.	Refer to CREATE TABLE [create_table(7)] for details.

       table_name
	      The name (optionally schema-qualified) of the table to be created.

       column_name
	      The  name of a column in the new table. Multiple column names can be specified using a comma-delimited list of column names. If col-
	      umn names are not provided, they are taken from the output column names of the query.

       query  A query statement (that is, a SELECT command). Refer to SELECT [select(7)] for a description of the allowed syntax.

DIAGNOSTICS

       Refer to CREATE TABLE [create_table(7)] and SELECT [select(7)] for a summary of possible output messages.

NOTES

       This command is functionally equivalent to SELECT INTO [select_into(7)], but it is preferred since it is less likely to	be  confused  with
       other uses of the SELECT ... INTO syntax.

COMPATIBILITY

       This  command  is modeled after an Oracle feature. There is no command with equivalent functionality in SQL92 or SQL99. However, a combina-
       tion of CREATE TABLE and INSERT ... SELECT can accomplish the same thing with little more effort.

HISTORY

       The CREATE TABLE AS command has been available since PostgreSQL 6.3.

SEE ALSO

       CREATE TABLE [create_table(7)], CREATE VIEW [create_view(l)], SELECT [select(l)], SELECT INTO [select_into(l)]

SQL - Language Statements					    2002-11-22							CREATE TABLE AS(7)

UNIX and Linux Applications