This is the error message I get when I run the below scripts ERROR at line 1: ORA-00979: not a GROUP BY expression
开发者_运维问答 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.
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
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
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?
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
I have problem with my package its looks like: create or replace PACKAGE pac AS TYPE A IS RECORD ( aa VARCHAR2(255)
The following PL/SQL block works: DECLARE r TABLE1%ROWTYPE; BEGIN 开发者_开发百科SELECT * INTO r FROM TABLE1 SAMPLE(1) WHERE ROWNUM = 1;
I have the following code in an oracle procedure, which returns a cursor (r_cursor) as an OUT parameter
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:
加载中,请稍侯......