I got a bit of a problem with a Oracle query create or replace PROCEDURE\"LOAD_USERNAME\" IS cursor usu is
I\'d like to use bind variables instead of a string concatenation when I build up a dynamic SQL statement for execut开发者_Go百科e immediate.
I have this statement: SELECT passwdlib.piv_insertPasswd(:A1, :A开发者_运维百科2) FROM DUAL I am guessing that piv_insertPasswd is the name of function or SP, and passwdlib is the user name. Am i
Say I have a custom datatype that has a number of members. For example: create type myType as object( field1number,
I 开发者_Go百科have a query that uses the outputs(R1,R2) of two sub queries in order to divide them:
I\'m a newbie in PLSQL. I was ju开发者_运维技巧st wondering if I can save my formula into a table as string and use it in my functions to calculate some values.
I think I have a complex requirement. It\'s a combinatorial permutation using Oracle 10.2, I\'was able to solve it using cartesian joins, but I think that it need some improvements to made it simples
I am trying to create a trigger: create or replace trigger NAME_OF_TRIGGER after insert or update on table1
Please find below tables EVENT table event_id | gross_amount | transaction_id 1| 10| 1 2| 12| 5 TRANSACTION table
Question : Is it possible to return using OUT : Both : A variable & A cursor, from my code below ??
加载中,请稍侯......