plsql

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

Efficiently inserting multiple records in oracle db using Oracle client

I\'ve C#-WCF/Winforms application.It inserts 450,000 plus records in a staging table in Oracle database using Oracle Client API and a stored proc having a simple insert query.[详细]

2023-04-10 01:24 分类：问答
Format mask a currency amount in Oracle ApEx

I have a cost field in my Oracle ApEx form where the user may enter an $ amount of say 10000.00 or more or even less.[详细]

2023-04-10 00:43 分类：问答
Can only one procedure within a PL/SQL package be run with AUTHID CURRENT_USER?

开发者_StackOverflowI have a PL/SQL package that does not specify an AUTHID (effectively making it AUTHID DEFINER). However, there is precisely one procedure within this package that needs to run as A[详细]

2023-04-10 00:13 分类：问答
ORA-00907 when dynamically creating a view in PL/SQL and using a CLOB

This is one of those situations where you get an unhelpful error message back from Oracle. My situation is as follows: I\'m dynamically creating a view in PL/SQL. I build a string and use EXECUTE IM[详细]

2023-04-09 23:15 分类：问答
Updating Oracle Table using Stored Procedure from C# Odd bug

I am using a stored procedure to Insert a new user or update their existing information if the user already exists in the Database.[详细]

2023-04-09 16:40 分类：问答
Advise how to optimize the solution (LOOP for all records and check for errors)

I used the following (check for errors in loop and if 开发者_运维百科they are exists I insert they into the table):[详细]

2023-04-09 13:37 分类：问答
Writing verification steps for PL/SQL Sequence

I am writing the launch plan for one of my code. In which, for each step i have to write a verification step which will tell if the deployment/change has been made properly. Like if there is an alter[详细]

2023-04-09 08:44 分类：问答
Convert VARCHAR2 to TIMESTAMP in Oracle

I have a VARCHAR2 value in the format \'14-SEP-11 12.33.48.537150 AM\' and I need to convert this to a TIMESTAMP as is. That is like,[详细]

2023-04-09 06:01 分类：问答
Oracle PLSQL function throws PL/SQL: numeric or value error: character string buffer too small ,for returning large data

I have the following PLSQL functions that returns following error when returning a large data. ORA-06502: PL/SQL: numeric or value error: character string buffer too small[详细]

2023-04-09 05:20 分类：问答
Maven: PL/SQL script with sql-maven-plugin throws error PLS-00103

I\'m trying to use the sql-maven-plugin to execute a PL/SQL script on an Oracle 11 database. Although the script is valid PL/SQL (as far as I can tell), the execution gives me a PLS-00103 error:[详细]

2023-04-09 03:38 分类：问答