I have file with some data ~ delimiter
Like :
291207~12:13:12~abcd 112233~aaaaa
291207~12:14:12~abcd 112233~aaaaa
291207~12:14:12~abdf 112233~aaaaa
291207~12:24:12~abdf 112233~bbbb
I want to have on output lines count but only for uniq column 3 , other columns are not important but I want to...
sample pl/sql file
demo.sql:
set serveroutput on size 1000000;
set echo off;
set trim off;
variable status number;
trash Boolean;
declare
error_code varchar2(100);
:status:=2;
trash:=fn_a(error_code);
if not trash
then
:status:=1;
else
:status:=0;
end if;
end;
/
column status new_value...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.