Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 03 Feb 2014 @ 16:06:57 GMT


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


Subj:   1:1 Views - Sel * from Table OR SELECT all columns from table
 
From:   Bodla, Sravan Kumar

Hi Forum,

Could you please let me know the difference and advantageous between these two.

1). Creating View by listing ALL columns of table.

     Replace view 
     As locking row for access
     Select
     Col1,
     Col2,
     ...
     ...
     Coln,
     From
     ;

2). Creating View by Sel * from table:

     Replace view 
     as locking row for access
     sel * from ;

Thanks,

Sravan.

SRAVAN KUMAR BODLA
GCC International - Technical Consultant



     
  <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: 27 Dec 2016