Welcome To Ask or Share your Answers For Others

Recent questions tagged plsql

0 votes

1.3k views

1 answer

plsql - DBMS_OUTPUT.PUT_LINE not printing

When executing the following code, it just says the procedure is completed and doesn't print the ... firstNamea.lastName multiple times! See Question&Answers more detail:os...

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

0 votes

873 views

1 answer

plsql - How to pass object of object type as a parameter in oracle

This is the next level question for how to pass object type as a parameter in oracle. My question is in the same ... /how-to-pass-object-of-object-type-as-a-parameter-in-oracle...

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

0 votes

936 views

1 answer

plsql - PL/SQL: Confused about type coercion in function calls (stack frames)

Consider the following example: create or replace function f(n integer) return integer as begin return n; end; ... -sql-confused-about-type-coercion-in-function-calls-stack-frames...

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

0 votes

843 views

1 answer

plsql - insert value procedure in PL/SQL

I'm new to PL/SQL.i need a procedure that insert value . i created QABZ table table QABZ i wrote a ... https://stackoverflow.com/questions/65874276/insert-value-procedure-in-pl-sql...

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

0 votes

1.1k views

1 answer

plsql - How to extract an attachment which is a MTOM XOP from SOAP response using PL/SQL

I am trying to extract an attachment which is a MTOM XOP from a SOAP response using PL/SQL(UTL_HTTP plugin). I ... attachment-which-is-a-mtom-xop-from-soap-response-using-pl-sql...

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

0 votes

911 views

1 answer

plsql - Oracle - How to execute this script in parallel

I have a script to kill all sessions in Oracle: declare begin for rec in ( SELECT username,machine,sid, ... com/questions/65887705/oracle-how-to-execute-this-script-in-parallel...

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

0 votes

850 views

1 answer

plsql - RTTI in Oracle Triggers

I have this dummy types : create or replace type Service_TY as object( code INTEGER, visit_analysis char(1) ... https://stackoverflow.com/questions/65888422/rtti-in-oracle-triggers...

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

0 votes

933 views

1 answer

plsql - Oracle SQL: Running insert statements from a large text file

I have a large text file (around 50mb). This text file has thousands of insert statements. I tried to open ... /65908216/oracle-sql-running-insert-statements-from-a-large-text-file...

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

0 votes

1.0k views

1 answer

plsql - Alternative to V$LOCKED_OBJECT for finding locked tables

V$VERSION: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production select count(*) ... /65928054/alternative-to-vlocked-object-for-finding-locked-tables...

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

0 votes

835 views

1 answer

plsql - Oracle SQLDevelopper SQL TRIGGER Creation Problem That I Can't Figure Out

I want to create a trigger that manages 2 magazines, 'Elle' and 'Time'. So if the user tries to insert ... /oracle-sqldevelopper-sql-trigger-creation-problem-that-i-cant-figure-out...

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

0 votes

1.0k views

1 answer

plsql - ERROR at line 6: PL/SQL: SQL Statement ignored

I am getting an error at line 6: PL/SQL: SQL Statement ignored. The line with "select count(*) into ecount" ... .com/questions/65600021/error-at-line-6-pl-sql-sql-statement-ignored...

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

0 votes

855 views

1 answer

plsql - Call a stored procedure in a trigger PL/SQL

Well I'm trying to call a stored procedure in my trigger. The error I'm getting "table %s.%s is mutating, ... .com/questions/65601646/call-a-stored-procedure-in-a-trigger-pl-sql...

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

0 votes

844 views

1 answer

plsql - Can you use Object Types in Procedures in Oracle PL/SQL?

Hello fellow programmers. Im currently working on a webshop database for my studying program. Currently im trying to make a ... -you-use-object-types-in-procedures-in-oracle-pl-sql...

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

0 votes

812 views

1 answer

plsql - Oracle PSQL getting reason of error in a with as expression

I have a more thousand lines "with as" sql. When I try to run it I've got a message: "Expression must ... /66048247/oracle-psql-getting-reason-of-error-in-a-with-as-expression...

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

0 votes

934 views

1 answer

plsql - Deletion is slow in oracle DB

We have a table that doesn't have much data. The table has 3 partitions and we are deleting data in one ... ://stackoverflow.com/questions/66048564/deletion-is-slow-in-oracle-db...

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

0 votes

1.0k views

1 answer

plsql - How to write a CLOB to an OS file in Oracle without using UTL_FILE package?

I have a variable xml_ which is a CLOB data type variable I use to store some XML data using a PL/SQL procedure ... -clob-to-an-os-file-in-oracle-without-using-utl-file-package...

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

0 votes

982 views

1 answer

plsql - How to write a CLOB to an OS file in Oracle without using UTL_FILE package?

I have a variable xml_ which is a CLOB data type variable I use to store some XML data using a PL/SQL procedure ... -clob-to-an-os-file-in-oracle-without-using-utl-file-package...

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

0 votes

939 views

1 answer

plsql - Oracle query logic to identify email addresses across the dwh schemas

I was performing an activity to identify eMail addresses based on certain pattern (@xyz.de). I initially tried ... -query-logic-to-identify-email-addresses-across-the-dwh-schemas...

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

0 votes

807 views

1 answer

plsql - Formatting SQL WHERE Conditional Values

I am looking to see if there is a way to format conditional values in batch instead of manually ... //stackoverflow.com/questions/66065923/formatting-sql-where-conditional-values...

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

0 votes

794 views

1 answer

plsql - Formatting SQL WHERE Conditional Values

I am looking to see if there is a way to format conditional values in batch instead of manually ... //stackoverflow.com/questions/66065923/formatting-sql-where-conditional-values...

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

0 votes

942 views

1 answer

plsql - I m trying to make pipelined table function call but i m getting error in package body. Can u please make it correct

create or replace Type e_record AS Object( e_uid number, e_first_name varchar2(50) , e_last_name varchar2(50), e_age number, ... type Error at line 8: PL/SQL: SQL Statement ignored...

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

0 votes

950 views

1 answer

plsql - I m trying to make pipelined table function call but i m getting error in package body. Can u please make it correct

create or replace Type e_record AS Object( e_uid number, e_first_name varchar2(50) , e_last_name varchar2(50), e_age number, ... type Error at line 8: PL/SQL: SQL Statement ignored...

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

0 votes

1.2k views

1 answer

plsql - Oracle SQL - select a subquery from a view

I have a short and quick question regarding the feasability of selecting a subquery that exists within a view. Say I ... clarify, I'd like to know if there exists alternatives....

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

0 votes

992 views

1 answer

plsql - the update query is not working in oracle sql developer , what is the error?

DECLARE @A varchar2(20); BEGIN @A := 'abc555'; UPDATE TEST Set LINK = Replace(LINK,Substring(LINK,1,CHARINDEX('ESSAIS-CGMP',LINK)-1),@A); END;...

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

0 votes

1.2k views

1 answer

plsql - ERROR at line 6: PL/SQL: SQL Statement ignored

I am getting an error at line 6: PL/SQL: SQL Statement ignored. The line with "select count(*) ... where table_employee.dept_name=deparment and salary>500000; return ecount; end;...

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

0 votes

1.0k views

1 answer

plsql - Call a stored procedure in a trigger PL/SQL

Well I'm trying to call a stored procedure in my trigger. The error I'm getting "table %s.%s is mutating, ... Trigger code is working. But the stored procedure causes the error....

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

0 votes

1.1k views

1 answer

plsql - Does anyone know how to translate this mysql(trigger) syntax to oracle syntax?

CREATE DEFINER=`belito`@`%` TRIGGER `sumupdate` AFTER INSERT ON `stavkaotpremnice` FOR EACH ROW UPDATE otpremnica a SET ... doing it, made some searches but didnt go nowhere....

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

0 votes

1.2k views

1 answer

plsql - Nested Subquery in Oracle Apex 20.1 chart

for my chart in Oracle Apex 20.1 i want to implement a nested subquery where data shown depends on someones permission in ... how to solve this. Any help is appreciated. Thank you....

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

To see more, click for the full list of questions or popular tags.

...