plsqldeveloper
if-else, case or decode inside of a ref cursor
I have this big code where I want 3 things in my search: 1- look for all the orders (delivered and not) that match the search:[详细]
2022-12-17 03:56 分类:问答Looping through nested tables in oracle and returning a list of objects to java
I have this table created as follow: CREATE TABLE FORNECPRODS (SUPPLIER FORNEC_OBJ , PRODUCTS PRODTABLE[详细]
2022-12-16 17:13 分类:问答Customize PL/SQL exceptions in Oracle
Frequently I found myself doing some functions to insert/delete/update in one or more tables and I\'ve seen some expected exceptions been taken care of, like no_data_found, dupl_val_on_index, etc. For[详细]
2022-12-16 10:00 分类:问答How to connect to remote Oracle DB with PL/SQL Developer?
I have a database \"TEST\", to which I connect at address 123.45.67.89:1521. H开发者_如何学运维ow do I connect to it using PL/SQL Developer?In the \"database\" section of the logon dialog box, enter[详细]
2022-12-13 13:14 分类:问答oracle pl/sql bug: can't put_line more than 2000 characters
Has anyone else noticed this phenomenon where dbms_output.put_line is unable to print more than 2000 characters at a time?[详细]
2022-12-11 19:22 分类:问答
加载中,请稍侯......