plsql

相关标签：javascript jquery android 多少钱 iPhone

Oracle error: cannot perform DML in a query

Why do I get the following error? Error starting at line 1 in command: select FUNC from dual Error report:[详细]

2023-04-02 06:32 分类：问答
Oracle PL/SQL string compare issue

I have the following Oracle PL/SQL codes that may be rusty from you guys perspective: DECLARE str1varchar2(4000);[详细]

2023-04-02 05:54 分类：问答
PL/SQL: Count number of nodes in xml

I am working with Oracle. Is there a way to count the number of nodes (including descendants) within an XML file using PL/SQL?[详细]

2023-04-02 01:16 分类：问答
AES Encryption in Oracle and MySQL are giving different results

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[详细]

2023-04-01 23:15 分类：问答
PL/Sql procedure vs function? [duplicate]

This question already has answers here: What is the difference between function and procedure in PL/SQL?[详细]

2023-04-01 16:38 分类：问答
Update unique rows in 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[详细]

2023-04-01 16:00 分类：问答
Is there a PL/SQL pragma similar to DETERMINISTIC, but for the scope of one single SQL SELECT?

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):[详细]

2023-04-01 15:59 分类：问答
How to cancel the insertion of records (create_record;) in Oracle Forms? Like a cancel button

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[详细]

2023-04-01 09:06 分类：问答
how i do this in oracle pl/sql

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:[详细]

2023-04-01 08:50 分类：问答
where to define default value in oracle package

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 ([详细]

2023-04-01 06:57 分类：问答