Recent questions tagged plsql

0 votes

452 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)

0 votes

313 views

1 answer

plsql - SQL Distinct keyword bogs down performance?

I have received a SQL query that makes use of the distinct keyword. When I tried running the query it took at least a ... 01-01', 'YYYY/MM/DD') See Question&Answers more detail:os...

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

0 votes

661 views

1 answer

plsql - create oracle package encountered PLS-00103: Encountered the symbol "CREATE"

I am writing an oracle package using Oracle sql developer, I got this compile error: Error(7,1): PLS-00103: ... package1; I got the same err. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

plsql - Oracle - ORA-06502: PL/SQL: numeric or value error (DBMS_OUTPUT)

I implemented a function that returns clob data-type, and I would like to print the result in DBMS Output. ... 0.3.0 - 64bit Production See Question&Answers more detail:os...

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

0 votes

360 views

1 answer

plsql - How to run multiple SQL queries?

I have a create table query, an update query ,and then drop table query. I need to run these three queries ... or some other way. Please help. See Question&Answers more detail:os...

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

0 votes

555 views

1 answer

plsql - Oracle SQL Query for listing all Schemas in a DB

I wanted to delete some unused schemas on our oracle DB. How can I query for all schema names ? See Question&Answers more detail:os...

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

0 votes

517 views

1 answer

plsql - What is bad in "When Others Then Null" in PL/SQL?

I just read this question, and a solution states that: The fact that you don't know you got the NO_DATA_FOUND ... do to avoid doing that... See Question&Answers more detail:os...

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

0 votes

704 views

1 answer

plsql - mysql - How to handle query search with special characters /(forward slash) and (backslash)

I am having table where a column allows special characters like '/' forward slash and '' back slash. Now when I ... case, let me know. Thanks. See Question&Answers more detail:os...

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

0 votes

632 views

1 answer

plsql - Oracle: Insert rowtype data into another table

I have one table called event, and created another global temp table tmp_event with the same columns and definition ... insert on EVENT table ? See Question&Answers more detail:os...

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

0 votes

561 views

1 answer

plsql - mysql - How to handle query search with special characters /(forward slash) and (backslash)

I am having table where a column allows special characters like '/' forward slash and '' back slash. Now when I ... case, let me know. Thanks. See Question&Answers more detail:os...

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

0 votes

567 views

1 answer

plsql - TO_CHAR of an Oracle PL/SQL TABLE type

For debugging purposes, I'd like to be able to "TO_CHAR" an Oracle PL/SQL in-memory table. Here's a simplified ... use it with any table type. See Question&Answers more detail:os...

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

0 votes

581 views

1 answer

plsql - Taking dump of tables in oracle 10g using PL/SQL procedure

Hi Required immediate response, I want to take dump of some selected tables from schema, can any body tell me is ... T5 only. Thanks in advance See Question&Answers more detail:os...

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

0 votes

641 views

1 answer

plsql - How to efficiently convert text to number in Oracle PL/SQL with non-default NLS_NUMERIC_CHARACTERS?

I'm trying to find an efficient, generic way to convert from string to a number in PL/SQL, where the local setting ... I'd give it credit for? See Question&Answers more detail:os...

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

0 votes

412 views

1 answer

plsql - How to get list of all the procedure inside a package oracle

Can I get the name of all the function inside a package. Suppose I have a package PKG_OWA and I want ... all the procedure inside the package. See Question&Answers more detail:os...

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

0 votes

301 views

1 answer

plsql - What is the equivalent of SQL Server APPLY in Oracle?

I am new to Oracle. Is there a builtin keyword does the same job of SQL Server APPLY? See Question&Answers more detail:os...

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

0 votes

437 views

1 answer

plsql - What is the difference between explicit and implicit cursors in Oracle?

I am a bit rusty on my cursor lingo in PL/SQL. Anyone know this? See Question&Answers more detail:os...

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

0 votes

329 views

1 answer

plsql - How can I drop a "not null" constraint in Oracle when I don't know the name of the constraint?

I have a database which has a NOT NULL constraint on a field, and I want to remove this constraint. ... when logically dropping that constraint? See Question&Answers more detail:os...

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

0 votes

514 views

1 answer

plsql - How to select into a variable in PL/SQL when the result might be null?

Is there a way in to just run a query once to select into a variable, considering that the query might ... kind of hesitate of goto lines. See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

plsql - Oracle datatype: Should I use VARCHAR2 or CHAR

Should I use VARCHAR2 or CHAR as a datatype in Oracle? It's been suggested to me to use CHAR for these ... and buggy. What are your opinions? See Question&Answers more detail:os...

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

0 votes

570 views

1 answer

plsql - Possible to create Oracle Database object types inside of PL/SQL?

Is it possible to create an object type inside of a package in Oracle Database 10g? Something like: create or ... of packages. Thanks, Jeff See Question&Answers more detail:os...

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

0 votes

435 views

1 answer

plsql - Writing in ExcelSheet using UTL_FILE package in Oracle

I have no problem in writing data in excel sheet which is stored in some predefined directory. Now I ... FCLOSE(FILENAME); END SP_ORACLE_EXCEL; See Question&Answers more detail:os...

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

0 votes

485 views

1 answer

plsql - How to write to files using utl_file in oracle

How to use put function.my procedure is not compiling with put. but putline is working fine. i want to print in the same line See Question&Answers more detail:os...

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

0 votes

509 views

1 answer

plsql - Selecting Values from Oracle Table Variable / Array?

Following on from my last question (Table Variables in Oracle PL/SQL?)... Once you have values in an array/ ... table. Thanks in advance, Matt See Question&Answers more detail:os...

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

0 votes

335 views

1 answer

plsql - How do I get column datatype in Oracle with PL-SQL with low privileges?

I have "read only" access to a few tables in an Oracle database. I need to get schema information on some of ... to with a PL-SQL statement? See Question&Answers more detail:os...

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

0 votes

415 views

1 answer

plsql - Reset Sequence in oracle 11g

I am trying to reset the sequence to 1 dynamically using the following procedure in oracle 11g. create or replace ... 10g before it worked fine. See Question&Answers more detail:os...

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

0 votes

576 views

1 answer

plsql - How to create a oracle sql script spool file

I have a question about spooling the the results of my program. My sample sql script looks like this. whenever ... spool those results. Thanks. See Question&Answers more detail:os...

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

0 votes

407 views

1 answer

plsql - automating rollback script oracle

When releasing database code to non-development databases , I use such approach - I create release sqlplus script ... /rollback pl/sql code? See Question&Answers more detail:os...

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

0 votes

416 views

1 answer

plsql - Oracle Regexp to replace , and with space

I am trying to select a column from a table that contains newline (NL) characters (and possibly others , , ). ... characters with a space, " ". See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags