plsql

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

I've seen one but... what exactly is a 10g Package?

Scenario: I know nothing about packages except that they contain functions and procedures all wrapped into a nice little present. So today I was given this package (rather large) with the instructions[详细]

2023-04-09 02:50 分类：问答
ORA-22813: operand value exceeds system limits

I\'m having an issue with an oracle object I created. The goal of the stored procedure is to either retreive all wires contained on an airplane or compare the list of wires with another one (past airp[详细]

2023-04-09 02:01 分类：问答
Getting an Error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"

I have a below Package which is giving error ORA-06502: PL/SQL: numeric or value error: character string buffer too small[详细]

2023-04-08 11:48 分类：问答
Oracle multiple statments do not run correctly

I have a file with 3 \"create type\" statements. I do not understand why, when I run the script it creates only the first type. When I open created type I see all three create statements inside开发者_[详细]

2023-04-08 10:28 分类：问答
Declaring a variable and setting its value from a SELECT query in Oracle

In SQL Server we can use this: DECLARE @variable INT; SELECT @variable= mycolumn from myTable; How can I do the same in Oracle? I\'m c开发者_运维百科urrently attempting the following:[详细]

2023-04-08 06:48 分类：问答
oracle rollback and commit

In the following sql statements: BEGIN update开发者_运维百科 table1 set col1 = \'Y\'; commit; update table2 set col2 = \'Y\';[详细]

2023-04-07 23:21 分类：问答
Error using UTL_MAIL in a SQL procedure

I am attempting to send an开发者_运维知识库 email using a sql procedure, and am getting some errors.Here is my relevant code:[详细]

2023-04-07 19:07 分类：问答
Oracle - Audit Trail

Does oracle have Audit Trail as an inbuilt functionality? Do i need to create separate table for Audit Log purpose to capture INSERT,开发者_StackOverflow社区 UPDATE and DELETE changes?Yes, Oracle doe[详细]

2023-04-07 18:39 分类：问答
How can I use a collection within an Oracle SQL statement

I want to write an Oracle function that collects some data in multiple steps into a collection variable and use that collection data within a SELECT query like in this very simplified example:[详细]

2023-04-07 18:02 分类：问答
PL/SQL Exception Translation

I am inserting a new object in my database table, but I keep on retrieving a exception that states....[详细]

2023-04-07 12:15 分类：问答