Need help in select statetment

Special Forums Windows & DOS: Issues & Discussions Need help in select statetment

Prev Next

07-20-2012

Registered User

11,728, 1,345

Join Date: Feb 2004

Last Activity: 8 May 2020, 9:07 AM EDT

Location: NM

Posts: 11,728

Thanks Given: 903

Thanked 1,345 Times in 1,201 Posts

Code:

set serveroutput on size 100000
DECLARE 

flag VARCHAR2(50); 
STATEMENT VARCHAR2(255); 

BEGIN 
  dbms_output.enable(100000);
 SELECT SUBSTR(flag, 1,2) 
   INTO flag 
 FROM xxx.sms; 
 IF flag = 1 THEN 
   dbms_output.put_line('welcome');
 ELSE
   dbms_output.put_line('try again');
 END IF;
END ;

Try that.

jim mcnamara

View Public Profile for jim mcnamara

Find all posts by jim mcnamara

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Select command

Hi I'm using the "select" command in the global_env.sh to log in to the application directory. This file is called in .bashrc profile. Sample code: Filename: global_env.sh set -o vi export severname=$(uname -n) printf '%s\n%30s\n%s\n' "***********************" "Welcome to $severname"...

2. Programming

Socket and select

I have created two sockets and binded both. My requirement is that 2nd socket must send/ recv data only on expiration of timeval(tv). but the 1st socket must keep on send/recv the data without waiting for the 2nd socket completion...... I have posted my code below...... In this code the 2nd...

3. Boot Loaders

Reboot and Select Proper Boot device or insert Boot media in select Boot device and press a key

Hello, I have kubuntu on my laptop and now I decided to switch to Windows 7. I made the bios settings properly (first choice is boot from cd\vd) but I see the error " reboot and select proper Boot device or insert Boot media in select Boot device and press a key " I have tried CD and...

4. Programming

Problems with select

Is select only supposed to report state changes on an FD's, state, whether or not it had pending input available in the first place? I've got a situation where select() repeatedly reports no FD's ready for stdin when there's lots of data available. And if it only reports changes, how is this...

5. Shell Programming and Scripting

Select everything before a pattern

Hi I have i doubt, actually i have to select everything before a word(pattern).For that i am using sed i am using the below line of code but it is not working i am getting a blank instead.. sed -n '/regexp/{g;1!p;};h' file1 Can anyone help? Thanks

6. Shell Programming and Scripting

select a column

I've a file like this: andrea andre@lol.com october antonio@lol.com marco 45247@pop.com kk@pop.com may pollo@lol.com mary mary@lol.com can I select only the column with email adress? can I utilise a filter with @ ? I want obtain this: ...

7. UNIX for Advanced & Expert Users

Doubt regarding Select()

Please provide the solution for the following scenario: 1) There are two process named as ProcessA and ProcessB 2) ProcessA has opend a named pipe in read mode.This has been made as blocking mode. 3) ProcessB opens this pipe and writes in Blocking mode.So wat happens is even if Process A goes...

8. Shell Programming and Scripting

How to select Shell

We are using the line #!/usr/bin/ksh in the script, to run the script in ksh. If I have Bash shell and Ksh, how to select the shell to run the script during runtime? Thanks in advace Victor

9. IP Networking

select vs poll

Hi, Off late I had been looking at the differences b/w select() & poll() system calls. The requirement is to reduce the overhead, processor power in waiting for the data. In the kind of connections under consideration there would be very frequent data arriving on the sockets, so poll() fares...

10. UNIX for Dummies Questions & Answers

Select ALL in VI Editor

Hi all, How can i select all and copy text in VI Editor. Rakesh Gupta

LEARN ABOUT REDHAT

insert

INSERT(7)							   SQL Commands 							 INSERT(7)

NAME

       INSERT - create new rows in a table

SYNOPSIS

       INSERT INTO table [ ( column [, ...] ) ]
	   { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) | SELECT query }

   INPUTS
       table  The name (optionally schema-qualified) of an existing table.

       column The name of a column in table.

       DEFAULT VALUES
	      All columns will be filled by null values or by values specified when the table was created using DEFAULT clauses.

       expression
	      A valid expression or value to assign to column.

       DEFAULT
	      This column will be filled in by the column DEFAULT clause, or NULL if a default is not available.

       query  A valid query. Refer to the SELECT statement for a further description of valid arguments.

   OUTPUTS
       INSERT oid 1
	      Message returned if only one row was inserted.  oid is the numeric OID of the inserted row.

       INSERT 0 #
	      Message returned if more than one rows were inserted.  # is the number of rows inserted.

DESCRIPTION

       INSERT  allows one to insert new rows into a table. One can insert a single row at a time or several rows as a result of a query.  The col-
       umns in the target list may be listed in any order.

       Each column not present in the target list will be inserted using a default value, either a declared DEFAULT value or NULL. PostgreSQL will
       reject the new column if a NULL is inserted into a column declared NOT NULL.

       If the expression for each column is not of the correct data type, automatic type coercion will be attempted.

       You must have insert privilege to a table in order to append to it, as well as select privilege on any table specified in a WHERE clause.

USAGE

       Insert a single row into table films:

       INSERT INTO films VALUES
	   ('UA502','Bananas',105,'1971-07-13','Comedy',INTERVAL '82 minute');

       In this second example the last column len is omitted and therefore it will have the default value of NULL:

       INSERT INTO films (code, title, did, date_prod, kind)
	   VALUES ('T_601', 'Yojimbo', 106, DATE '1961-06-16', 'Drama');

       In the third example, we use the DEFAULT values for the date columns rather than specifying an entry.

       INSERT INTO films VALUES
	   ('UA502','Bananas',105,DEFAULT,'Comedy',INTERVAL '82 minute');
       INSERT INTO films (code, title, did, date_prod, kind)
	   VALUES ('T_601', 'Yojimbo', 106, DEFAULT, 'Drama');

       Insert  a  single  row  into  table  distributors;  note that only column name is specified, so the omitted column did will be assigned its
       default value:

       INSERT INTO distributors (name) VALUES ('British Lion');

       Insert several rows into table films from table tmp:

       INSERT INTO films SELECT * FROM tmp;

       Insert into arrays (refer to the PostgreSQL User's Guide for further information about arrays):

       -- Create an empty 3x3 gameboard for noughts-and-crosses
       -- (all of these queries create the same board attribute)
       INSERT INTO tictactoe (game, board[1:3][1:3])
	   VALUES (1,'{{"","",""},{},{"",""}}');
       INSERT INTO tictactoe (game, board[3][3])
	   VALUES (2,'{}');
       INSERT INTO tictactoe (game, board)
	   VALUES (3,'{{,,},{,,},{,,}}');

COMPATIBILITY

   SQL92
       INSERT is fully compatible with SQL92.  Possible limitations in features of the query clause are documented for SELECT [select(7)].

SQL - Language Statements					    2002-11-22								 INSERT(7)

Windows & DOS: Issues & Discussions