I have made stored procedures in oracle. I\'m calling it through my asp.net code. The procedure is : PROCEDURE prc_GetNewQuestionNo(iNextQuestionNo IN OUT NUMBER)
I\'ve got a PL/SQL VArray that I\'m filling with a BULK COLLECT query like this: SE开发者_运维技巧LECT id
I have a table in my database, user_answers that stores users answers to a series of questions, with rows; user_id, question_id, answer_id and text_entry.Question text and answer text (if any) are sto
I have several Oracle queries that perform well when run through SQL*PLUS.However when they are executed as a part of a PL/SQL package, they take MUCH longer.
Okay, I have reached a sort of an impasse. In my open source project, a .NET-based Oracle database browser, I\'ve implemented a bunch of refactoring tools. So far, so good. The one feature I was real
I have two variables MAX_TABLE_ID INTEGER; NEXT_TABLE_ID INTEGER; I\'m reading values into these and then trying to alter a sequence based on them
I have a query where I want to replace avg(j2) with avg(case when j2 <> 0 then j2 else 0 end) The above is a specific example but the pattern is the same with all the replacements. It\'s a
Can someone help me correct the Trigger below? I am assigned this problem but my technical skill is limited.
I am trying to get my stored procedure working in Oracle and am getting an Underflow error.I am trying to delete related information from six different tables.I can run the delete statements separatel
I\'m trying to turn free-form text into something more structured. I have a complex pattern that matches the great majority (well above the minimum acceptable limit) of the data availab开发者_运维知识
加载中,请稍侯......