Archives of the TeradataForum

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

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

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>>