Re: [GENERAL] select md5 result set

2017-08-03 Thread Jeff Janes
On Wed, Aug 2, 2017 at 4:25 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Aug 2, 2017 at 3:42 PM, Peter Koukoulis > wrote: > >> >> SQL> select dbms_sqlhash.gethash('select x,y from test1',2) as md5_value >> from dual; >> >> MD5_VALUE >> -

Re: [GENERAL] select md5 result set

2017-08-02 Thread David G. Johnston
On Wed, Aug 2, 2017 at 4:50 PM, Peter Koukoulis wrote: > david, thanks for the help. > > Would this be the equivalent, for the statement in your email, for table > TEST1 (x integer, y varchar(20)): > > ft_node=# SELECT md5(string_agg(vals::text, '')) > ft_node-# from (select x,y from test1) vals(

Re: [GENERAL] select md5 result set

2017-08-02 Thread Peter Koukoulis
david, thanks for the help. Would this be the equivalent, for the statement in your email, for table TEST1 (x integer, y varchar(20)): ft_node=# SELECT md5(string_agg(vals::text, '')) ft_node-# from (select x,y from test1) vals(x,y); ? Peter On Thu, 3 Aug 2017 at 00:25 David G. Johnston wrote

Re: [GENERAL] select md5 result set

2017-08-02 Thread David G. Johnston
On Wed, Aug 2, 2017 at 3:42 PM, Peter Koukoulis wrote: > > SQL> select dbms_sqlhash.gethash('select x,y from test1',2) as md5_value > from dual; > > MD5_VALUE > > > 9FDA7FA725B783172CA371DA04AD5754 > > > Can I do so