Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
create or replace FUNCTION Proc(schema_name in VARCHAR) RETURN NUMBER IS SQL_TXT VARCHAR(700); BEGIN SQL_TXT:= 'UPDATE '||schema_name||'.my_table x set ( line ) = ( select y.val from (select emp_no, line, row_number() over (partition by emp_no order by line ) as val from '||schema_name||'.my_table ) y where x.emp_no = y.emp_no and x.line = y.line) EXECUTE IMMEDIATE SQL_TXT; RETURN SQL%ROWCOUNT; EXCEPTION WHEN OTHERS THEN RAISE_APPLICATION_ERROR(-20001,'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM); RETURN -1; END;
|JDeveloper 12c for 32 bit||4||35|
|Run query in Access VBA and assign result to unbound text box on form||4||32|
|get most recent and second most recent date in SQL Server||24||46|
|Fixed Length SQL Query Question||3||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!