Recent questions tagged plsql

0 votes

812 views

1 answer

plsql - sqldeveloper - DBMS_OUTPUT.PUT_LINE() Doesn't Work

I am trying to print the value passed to the DBMS_OUTPUT.PUT_LINE() function to the DBMS_OUTPUT screen in SQL ... ". Kindly help. Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

695 views

1 answer

plsql - Date query ran in PL/SQL Developer shows time, but does not show in Oracle SQL Developer

The same query ran in PL/SQL Developer shows time, however it does not show in Oracle SQL Developer. Is there ... the details of the date field: See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

863 views

1 answer

plsql - PL/SQL function in Oracle cannot see DBMS_AQ

I have problem with Oracle 9.2 and JMS. I created PL/SQL routine to send XML text (from file or CLOB) to ... visible, but not in my procedure. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

572 views

1 answer

plsql - Store big JSON files into Oracle DB

I'm using the following script in order to read data from MongoDB as JSON files. DECLARE l_param_list VARCHAR2( ... (l_http_response); END; / See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

691 views

1 answer

plsql - Comma Separated values in Oracle

I have a column with comma separated values like 6,7,99.3334. I need write a PL SQL procedure that will give ... Can anyone help me with this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

629 views

1 answer

plsql - execute immediate create table and update table

I am creating a temp table in pl/sql using execute immediate & also inserting in the table why create table. After ... aa='1'; COMMIT ; end; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

529 views

1 answer

plsql - Oracle: Dynamic SQL

I am trying to write Oracle dynamic SQL to do row count, below is my approach, please help me complete. This ... ); l_sql varchar2(32000); begin See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

591 views

1 answer

plsql - Simple PL/SQL function to test if a string is a number

I'm experienced with T-SQL from SQL Server, but have recently begun working on a project utilizing an ... I'm missing something fundamental. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

911 views

1 answer

plsql - Convert PL/SQL to Hive QL

I want a tool through which I can get the respective hive query by giving the PL/SQL query. There are lots ... me. Thanks and Regards, Ratan See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

684 views

1 answer

plsql - Oracle how to export query to a text/csv file

I was wondering how to go about exporting a query from PL/SQL to an text file or csv file. The query I have ... have any idea how to do this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

769 views

1 answer

plsql - What is the size limit for a varchar2 PL/SQL subprogram argument in Oracle?

When you create a procedure (or a function) in Oracle PL/SQL, you cannot specify the maximum length of the ... to this procedure in Oracle ? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

496 views

1 answer

plsql - Oracle cursor for assignation

I have the below 2 tables: t1 VK AY AN R VK1 A1, A2 1 VK2 2 VK3 A1, A2, A3, A4 3 VK4 A2 4 VK5 5 ... 15 VK16 16 VK17 17 VK18 18 VK19 19 VK20 20 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

645 views

1 answer

plsql - How to sent email in Oracle PL/SQL package to multiple receivers?

How to sent email in Oracle PL/SQL package to multiple receivers? I have below pl/sql procedure within an oracle package, it ... -------------- See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

720 views

1 answer

plsql - Oracle PL/SQL select into variables

I am trying to run the following query in SQL Developer, but I am receiving an error. I am trying to ... PL/SQL compilation error. *Action: See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

429 views

1 answer

plsql - how to call the stored procedure in oracle with the daily scheduled jobs?

I am new to the oracle job scripts. I wrote some purge procedure to clean all the old data and retain the last ... guide me to solve this... See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

763 views

1 answer

plsql - How convert CLOB to BLOB in Oracle?

Firstly I converted a BLOB of an image to CLOB, and then converted that CLOB back to BLOB. I cannot see ... ; RETURN v_blob; END clob_to_blob2; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

521 views

1 answer

plsql - In Oracle, is there a function that calculates the difference between two Dates?

In Oracle, is there a function that calculates the difference between two Dates? If not, is a way to ... 2) as AveragegScheduleTime FROM table1 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

430 views

1 answer

plsql - How to find dependencies inside an oracle package?

My question is how to find inside oracle package dependencies by SQL query or any other internal/external tool. ... 'inside' one package. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

604 views

1 answer

plsql - How do I create an Oracle table with nested tables of object types?

I have a highly nested OBJECT TYPE structure that allows me to hold data in a tree-like manner. I'd ... table column or attribute Oracle 11g. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

572 views

1 answer

plsql - Oracle SQL Injection Block with DBMS_ASSERT

this code is firing errors query_string := 'SELECT '||dbms_assert.sql_object_name(trim(both ' ' from ... i get error ERR_INVALID_OBJECT See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

481 views

1 answer

plsql - Is there a best way to avoid execution of process more than once in Oracle?

Let's say that I have a procedure called myproc. This is a complex process and i cannot allow two instances ... a better way to check this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

548 views

1 answer

plsql - Return variable from cx_Oracle PL/SQL call in Python

I want to execute an Oracle PL/SQL statement via cx_oracle in Python. Code looks like this: db = cx_Oracle. ... the result back to Python? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

611 views

1 answer

plsql - Listing files in a specified directory using PL/SQL

Is it possible to get a list of all files (and their extensions) that are stored in a specified directory using only ... me how to do that :) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

616 views

1 answer

plsql - Oracle UTL_FILE read CSV file lines

i'm using UTL_FILE package to read a csv file , then insert values in table, but my issue is how to read ... suggestion to my issue ? Regards . See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

673 views

1 answer

plsql - PL/SQL - comma separated list within IN CLAUSE

I am having trouble getting a block of pl/sql code to work. In the top of my procedure I get some data ... a query within a pl/sql procedure? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

590 views

1 answer

plsql - Try Catch Like Exception Handling In Pl/Sql

In a procedure, I want to do logic unit 1, doesn't matter if it fails, execute logic unit 2 this ... second Exception block cause the problem. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

624 views

1 answer

plsql - How to see PL/SQL Stored Function body in Oracle

I have a stored function in Oracle database pAdCampaign.fGetAlgoGroupKey. How to see the code of this function.? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

546 views

1 answer

plsql - How to declare and display a variable in Oracle

I would like to declare and display a variable in Oracle. In T-SQL I would do something like this DECLARE @A ... can I do this in Oracle. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags