Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How can I select all IDs from a Column, when I dont have any Values

How can I select all IDs from a Column, when I dont have any Values

From: amir <amir_at_have-it.de>
Date: 30 Nov 2001 04:54:56 -0800
Message-ID: <30c35a4a.0111300454.49c9d9ea@posting.google.com> 





Hi,



I am looking for a Asterix like % for the Number Datatype.



Example:



For a Varchar-Column:


select id, name from table where name like '%';



For a Number-Column:


select id, name from table where id = ????



Wie use Oracle 8.1.


Thanks


Amir
Received on Fri Nov 30 2001 - 06:54:56 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US