Is there a way开发者_如何转开发 to encode a value using the unix crypt method in oracle 10g? (Other DBMS like MySQL support this)The DBMS_CRYPTO PL/SQL package has encryption, but none using the nati
I have installed oracle10g enterprise edition on my computer. I want to find the outliers from the dataset, how this can be achieved using the dbms_data_mining_transform package. I knew simple statist
I\'m new to Oracle Objects and I have a problem. I don\'t know how to dereference an item from a VARRAY of REFs. Below is some source code that reproduces the problem that I have.
How to properly call DBMS_OBFUSCATION_TOOLKIT.DESEncrypt? (without using PL/SQL if possible) select DBMS_OBFUSCATION_TOOLKIT.DESEncrypt(\'x\',\'y\') from dual;
I am creating a procedure like this CREATE OR REPLACE PROCEDURE MY_PROC AS CURSOR DLR_UPDT IS SELECT B.MDN开发者_运维知识库,A.AMNT
A few years ago in Oracle 10 or 9 I used a function which was something like \"DBMS_COL_2_VAL\" (This is definitely not the right function).
Is it possible to call/use JAVA Messaging Service (JMS) from PL/SQL? I know we can call java from pl/SQL, but calling java is different from calling JMS Queues or JMS Topics, because JMS depends upon
Is there any way to map the first table to the second table with an SQL query or, if too complicated, a PL/SQL block?
I am trying to read a xml from plsql procedure using the xmlparser package, i am getting this error ORA-31020: The operation is not 开发者_如何学JAVAallowed, Reason: Not supported
How can I fetch from a ref cursor that is returned from a stored procedure (OUT variable) and print the resulting rows to STDOUT in SQL*PLUS?
加载中,请稍侯......