I have some questions about stored procedures. Using select query inside the stored procedure is efficent or using select query in front end. Which is take less time and give the result is fast or if ...
create or replace procedure buyunits is mnav number; mpno varchar2(100); mtransactioncharge number; mservicecharge number; maccno number; cursor ecursor is select accno from sipholder where ...
I currently have a sproc that is used for reporting on a table similar to the one below: ID Weight QTY OtherData 1 20 12 1234 1 44 4 1234 ...
I am new to SQL, I have 3 tables and I want to perform following logic via a stored procedure. IF Table A.Item No = MasterTable. Iteam No Then, Add a Record in table Short Expiry where Unique ID = ...