I have a procedure like this: create or replace procedure pname (tn varchar2) is -- here开发者_开发技巧 i want to declare the variable
I am having recods as below -开发者_如何学Python--------------------------------------------------------------------
I wanted to have a function in PLSQL that would return an set of numbers, and then have a for loop that would iterate over that dataset and do something with it.
I created a user defined function to delete some data. It doesn\'t work with delete but works with select. I am Oracle 9i.
I have a table in Oracle DB which has a field where procedure names are stored. my goal is to create a menu procedure with a number parameter. So when i call it i want it to get procedure name by it\'
I am beginner to stored procedure. We need to create a stored procedure which should return all records or return only passed as IN parameter, procedure returns cursor.
Requirement The table XYZ contains the column p_type which contains the column name of PQR table . Now here I am fetching a record from the XYZ table and sum(amount) on the basis of the group by p_typ
i have following table in my database : idgrp#codeparent# ----------------- 010USNULL 030SF10 110SNULL
I have col1 in myTable which is varchar, and I have to insert here timestamp eg:- 09-MAY-11 10.23.12.0000 AM.
I am trying to write universal pl/sql to (re)enqueue message already enqueued (present in queue table in whatever state).
加载中,请稍侯......