plsql

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

Querying Oracle PLSQL

This is the error message I get when I run the below scripts ERROR at line 1: ORA-00979: not a GROUP BY expression[详细]

2023-04-12 04:41 分类：问答
Oracle: What should I know about SGA? [closed]

开发者_运维问答 It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical andcannot be reasonably answered in its current form.[详细]

2023-04-11 21:21 分类：问答
Exracting substring from given string

I have data as following 1)MAXO_INSTR_INTERFACE 2)MAXIS_VENDOR_INTERFACE 3)MAXIMOS_EMPS_INTERFACE2 I need to extract String开发者_开发百科 which is located betweenboth underscores in PL/SQL as[详细]

2023-04-11 18:47 分类：问答
How to store a parameter value in oracle procedure from webservice

So what i am looking to do is use a web service call to implement an oracle procedure. To be more specific: I what it so that when i put a value into a parameter in my web service and run it, i want t[详细]

2023-04-11 17:42 分类：问答
How can I insert an element into a nested table only if it doesn't exist?

I want to have a nested table holding custom objects, by adding them one by one from multiple cursors. But I don\'t want to have duplicates in the table. How can I achieve this?[详细]

2023-04-11 03:22 分类：问答
Insert large amount of data efficiently with SQL

Hi I often have to insert a lot of data into a table. For example, I would have data from excel or text file in the form of[详细]

2023-04-11 02:44 分类：问答
using record types - declaration and body in package

I have problem with my package its looks like: create or replace PACKAGE pac AS TYPE A IS RECORD ( aa VARCHAR2(255)[详细]

2023-04-10 18:53 分类：问答
Oracle PL/SQL: syntax error when using a variable within SAMPLE clause

The following PL/SQL block works: DECLARE r TABLE1%ROWTYPE; BEGIN 开发者_开发百科SELECT * INTO r FROM TABLE1 SAMPLE(1) WHERE ROWNUM = 1;[详细]

2023-04-10 12:12 分类：问答
Row in table is getting locked after modifying a certain cell in it in oracle

I have the following code in an oracle procedure, which returns a cursor (r_cursor) as an OUT parameter[详细]

2023-04-10 10:54 分类：问答
Using a cursor throughout a procedure

I am somewhat new to PL/SQL, and am having a little trouble using a cursor that I created. I am writing a procedure that sends emails to particular pe开发者_如何学JAVAople.Here is the relevant code:[详细]

2023-04-10 07:28 分类：问答