Why do I get the following error? Error starting at line 1 in command: select FUNC from dual Error report:
I have the following Oracle PL/SQL codes that may be rusty from you guys perspective: DECLARE str1varchar2(4000);
I am working with Oracle. Is there a way to count the number of nodes (including descendants) within an XML file using PL/SQL?
I am in need to compare data between an Oracle database and a MySQL database. In Oracle, the data is first encrypted with the AES-128 algorithm, and then hashed. Which means it is not possible to rec
This question already has answers here: What is the difference between function and procedure in PL/SQL?
I have a table id | col1 | col3| col4 1| x|r| 2| y|m| 3| z|p| 4| x|r| i have to update all unique rows of this table
In a SQL SELECT statement, I\'d like to execute a function that is deterministic for the scope of that SELECT statement (or transaction would be ok, too):
I\'m having a problem in cancelling a DML. I\'m a beginner in PL/SQL, sorry. My program is this. In runtime, there\'s an add button where you can add records. but what if I pressed the add button, a
I have the follow table: example: nodes: id_nodeid_parent -------------------- 13 32 2-1 I want to insert in other table the level of descent. For example:
when you define a package in oracle there is a like a header and then a body. One must define all parameters in both locations. I want to make one of the parameters optional for the calling program (
加载中,请稍侯......