Heyho, I\'m trying to set a Procedure like: Create or Replace Procedure MyProcedure1( x in number default 1,
Im new to cursors in Oracle. I have a piece of SQL that is contained in a variable. I want to open a cursor with this sql. How do I do this? Seems simple but all the examples I find just have the sql
I got a problem with oracle database ,i created a stored procedure and i wanted to p开发者_JS百科ass an array of items\' ids to this procedure to select the data according to array of items using \"in
I have a query like this: SELECT X.Y( \'p1\', \'p2\', \'p3\', \'p4\', \'100\') FROM dual I kn开发者_如何学Pythonow what dual is but this part X.Y( \'p1\', \'p2\', \'p3\', \'p4\', \'100\') really m
I have a table called Book. This table has 3 columns viz id, price and discount. If price is greater than 200 then discount should be 20%. While inserting data in Book table the discount value should
Does anybody know if there is a way to find what the length of the longest row in a column in Oracle? Basically I need to get the length of the longest row and then use that length plus 1
Recently, I encountered a BEFORE INSERT OR UPDATE trigger on a table. In this trigger, the author relies on the INSERTING and UPDATING functions (both return a BOOLEAN) of the DBMS_STANDARD package to
is it possible to send e-mail over ssl in plsql? thanks for helpin开发者_如何学Pythong.Not with pure PL/SQL afaik. We added some java classes to the database which performs the SSL mail sending with t
This question already has answers here: 开发者_如何学Go Finding and removing Non-ASCII characters from an Oracle Varchar2
Tiredness prevents me from finding this one... Say you have the following tables: Parent PARENT_ID (LONG)
加载中,请稍侯......