plsql Questions
2
I don't know how I can return all attributes with the RETURNING clause
I want something like this:
DECLARE
v_user USER%ROWTYPE
BEGIN
INSERT INTO User
VALUES (1,'Bill','QWERTY')
RETURNI...
Jodi asked 22/5, 2010 at 18:23
4
Solved
Please read before marking as duplicate
I have not been able to create or find a RegEx that works for all IPv6 formats (my test cases are below). I am aware of this question that everyone points t...
Presentationism asked 7/2, 2014 at 15:31
17
Solved
How do I convert a comma separated string to a array?
I have the input '1,2,3' , and I need to convert it into an array.
3
Can someone help me with this problem that occurs whenever you run a TRIGGER, but works in a normal PROCEDURE?
TRIGGER:
create or replace
procedure testeHTTP(search varchar2)
IS
Declare
req sy...
3
Solved
I am getting below error while generating 100k record in PL/SQL. I have created a package and calling that package from anonymous block.
Error report -
ORA-20000: ORU-10027: buffer overflow, limit ...
Wallflower asked 22/12, 2020 at 18:35
3
Solved
I have a procedure which receive as input parameter a record with 170 columns (it is based on the structure of a table).
In the procedure I want to call a debugging procedure one of whose paramete...
7
Solved
How can I create an Oracle stored procedure which accepts a variable number of parameter values used to feed a IN clause?
This is what I am trying to achieve. I do not know how to declare in PLSQL...
Trebuchet asked 28/10, 2008 at 10:19
10
Need Split function which will take two parameters, string to split and delimiter to split the string and return a table with columns Id and Data.And how to call Split function which will return a ...
5
Solved
I have this anonymous block:
DECLARE
V_DATA DATE;
BEGIN
V_DATA := '01-GEN-2000';
HR.STATISTICHE.RATINGOPERATORI (V_DATA);
COMMIT;
END;
but I would to generate the date in a random way. How ...
4
Solved
I do not understand, why my columns reg1 and reg2 remove "bbb" from my string, and only reg3 works as expected.
WITH t AS (SELECT 'aaa <b>bbb</b> ccc' AS teststring FROM dual)
SELECT...
3
I am trying to execute a block of PL/SQL code using JDBC request as below
set serveroutput on;
declare
..
BEGIN
DBMS_OUTPUT.ENABLE();
..
..
DBMS_OUTPUT.PUT_LINE(X);
END;
But I am getting error ...
3
Solved
Question:
How to perform string interpolation is Oracle using PLSQL? Given a template with named parameters enclosed within curly braces then substitute named parameters for variables. Functionalit...
8
Solved
I would like to find the distinct CLOB values that can assume the column called CLOB_COLUMN (of type CLOB) contained in the table called COPIA.
I have selected a PROCEDURAL WAY to solve this probl...
2
Solved
I have a procedure named MY_PROCEDURE_X in a packaged MY_PACKAGE_X.
My requirement is that the procedure need to be executed on 1st and 16th of every month.
If it is running on 1st of the Month, th...
5
Solved
I work in an Oracle instance that has hundreds of schemas and multiple developers. We have a development instance where developers can integrate their work before test or production.
We want to ha...
8
Solved
Say I have code like this
some_line_of_code
some_line_of_code
/* some comment about code */
some_line_of_code
some_line_of_code
and i would like to comment out a whole block like this
/*
some...
Cyd asked 21/5, 2015 at 13:45
3
Solved
Is it possible to run a for each loop on a PL/SQL array?
7
Solved
My installation of APEX has come pear shaped on a Oracle 9.2.0.5.0 instance, all the packages are invalid.
I've tried recompiling everything with DBMS_UTILITY.compile_schema, but still all the pac...
6
Solved
Im working on a pl-sql script, in which I have about 10 TO_CHAR conversions.
One of them is throwing an
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
exception.
...
4
Solved
Is cascade delete on a table more efficient than individual delete statements (executed in a single plsql block) ?
17
Solved
Can anyone help me understand when to use :NEW and :OLD in PLSQL blocks, I'm finding it very difficult to understand their usage.
3
Solved
I have a function in PL/SQL:
FUNCTION do_something
RETURN BOOLEAN
IS
...
BEGIN
...
END
This function can be called as such:
DECLARE
answer BOOLEAN;
BEGIN
answer := do_something();
END
No...
Laroche asked 10/2, 2014 at 12:27
5
Solved
How can I fetch from a ref cursor that is returned from a stored procedure (OUT variable) and print the resulting rows to STDOUT in SQL*PLUS?
ORACLE stored procedure:
PROCEDURE GetGrantListByPI(p...
Squamation asked 28/4, 2011 at 16:55
6
Solved
What is the string concatenation operator in Oracle SQL?
Are there any "interesting" features I should be careful of?
(This seems obvious, but I couldn't find a previous question asking it).
Craniometer asked 10/11, 2008 at 15:42
12
Solved
I need to write a procedure to normalize a record that have multiple tokens concatenated by one char. I need to obtain these tokens splitting the string and insert each one as a new record in a tab...
© 2022 - 2024 — McMap. All rights reserved.