plsql
IS there reflection in Oracle Forms 6 or later?
IS there reflection in Oracle Forms 6 or later? Is it possible to enumarate labels or othe开发者_开发问答r elements?Forms is an old and venerable programming language, and it doesn\'t support full-on[详细]
2023-04-13 09:24 分类:问答What is the equivalent syntax to grant Java running in the embedded Oracle JVM to an Oracle Directory by Name?
To grant java code that is running inside the Oracle JVM built into 10g DBMS to a specific directory on disk I can can execute:[详细]
2023-04-13 07:33 分类:问答How would I write a trigger to reorder a sequence number?
I have a simple table in Oracle with three columns: IDNCHAR(10) NAMENCHAR(50) SEQNUMBER The SEQ field is 0 based and there to allow the user to drag the records and reorder the list (using jQuery s[详细]
2023-04-13 05:37 分类:问答External Tables - "partial record at end of file" error when using FIXED
I am getting a \"partial record at end of file\" error when using FIXED parameter with External Tables.[详细]
2023-04-13 03:31 分类:问答T-SQL - how to swap multiple rows to one column
I have a resultset structure like this codeValue 1A0001 1A0002 2B0001 2B0002 2B0003 3C0001 4D0001 4D0002 ..... and I want to get to this:[详细]
2023-04-12 23:34 分类:问答bulk collect in oracle
How to query bulk collection?If for example I have select name bulk collect into namesValues 开发者_StackOverflow中文版from table1[详细]
2023-04-12 18:52 分类:问答same SQL concatenation opeartor for mysql,mssql,oracle
I am trying to use same sql statement for the above three DBMS .. but the problem is that it has string concatenation 开发者_高级运维involved but there are different ways in each dbms for concatenatio[详细]
2023-04-12 15:05 分类:问答PL/SQL send email with attachment?
we have a table with files saved as BLOB I write a code that email these files as an attachment! everything works fine so far, but the files (EXCEL,PDF, ... what ever) are not readable by the progra[详细]
2023-04-12 14:09 分类:问答Stored Procedure COMPILE Error
Can Someone help me on this , this is the error message I am gett开发者_StackOverflow社区ing when I run this script[详细]
2023-04-12 11:04 分类:问答Within a PL/SQL procedure, wrap a query or refcursor in HTML table
It seems really easy if you are using SQL*Plus to use SQL> set markup html on; and get some lovely results t开发者_如何学Goo the SQL*Plus window.we have an oracle job that runs overnight and se[详细]
2023-04-12 07:58 分类:问答