Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 30 Jul 2008 @ 10:40:51 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: How to achieve ROWID in Teradata
 
From:   sreenivasa.akula

Hi Nimmala,

Please find query and result below

     sel empno,rowid  from odsadm.emp (V2R5.0 Demo)

     EMPNO   ROWID
     1006    0000555500BE00000100
     1008    0000C6486FFA00000100
     1002    0000736E224500000100
     6001    0000C25B6CD200000100
     1005    00009FDBC81F00000100
     1004    0000E461918100000100
     3003    00002DDEC0F400000100
     1007    000010CF375C00000100
     1003    000029E859E300000100
     3001    0000BCEA51B800000100
     1001    0000B8F4EAA600000100


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023