Recent questions tagged Oracle

0 votes

1.1k views

1 answer

oracle - How to output result of SELECT statement which is executed using native dynamic SQL?

I have a string which contains SQL SELECT statement. I wonder how can I output result of the execution of ... . Any ideas very appreciated/ See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - ORA-12705: Cannot access NLS data files or invalid environment

The other day I got this annoying oracle error: ORA-12705: Cannot access NLS data files or invalid environment ... to access NLS data files See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - How to handle optional parameters in SQL query?

Say I have a sample table: id_pk value ------------ 1 a 2 b 3 c And I have a sample PL/SQL block ... of this kind. What would you advice me? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - How to drop multiple interval partitions based on date?

I have a table based on daily partitions. I can drop a paritition using the below query ALTER TABLE MY_TABLE ... partitions) before 15 days? See Question&Answers more detail:os...

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

0 votes

978 views

1 answer

oracle - How to use a table type in a SELECT FROM statement?

This question is more or less the same as this In the package header : Declared the following row type ... Variable inside my StoredProcedure. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Escaping single quote in PLSQL

I want PLSQL to generate strings like: COMMENT ON COLUMN TABLE.COLUMN IS 'comment from database'; My solution ... ROLLBACK. Any better solution? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - Base 36 to Base 10 conversion using SQL only

A situation has arisen where I need to perform a base 36 to base 10 conversion, in the context of a SQL ... gets a free upvote. Thanks Evil. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - PLS-00103: Encountered the symbol "CREATE"

What is the problem with this package as it is giving an error? CREATE OR REPLACE PACKAGE PKG_SHOW_CUST_DETAILS AS ... . What am I missing? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - PL/SQL print out ref cursor returned by a stored procedure

How can I fetch from a ref cursor that is returned from a stored procedure (OUT variable) and print the ... ; CLOSE grantCursor; END; / See Question&Answers more detail:os...

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

0 votes

974 views

1 answer

oracle - PL/SQL print out ref cursor returned by a stored procedure

How can I fetch from a ref cursor that is returned from a stored procedure (OUT variable) and print the ... ; CLOSE grantCursor; END; / See Question&Answers more detail:os...

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

0 votes

985 views

1 answer

oracle - How can I execute a native SQL script in JPA/Hibernate?

I have a SQL script with database dump. How can I execute it using Hibernate's EntityManager? I tried it this way ... 2.0.2.0 - 64bit Production See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - Using bind variables with dynamic SELECT INTO clause in PL/SQL

I have a question regarding where bind variables can be used in a dynamic SQL statement in PL/SQL. For example, ... a select like this. Thanks See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - Find out the history of SQL queries

An update SQL query was executed on the server, which caused many problems later. How can I get the list ... the exact problematic SQL query? See Question&Answers more detail:os...

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

0 votes

932 views

1 answer

oracle - Query to search all packages for table and/or column

Is there a query I can run to search all packages to see if a particular table and/or column is used in the ... value(s) I'm looking for. See Question&Answers more detail:os...

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

0 votes

811 views

1 answer

oracle - Trigger to enforce M-M relationship

Suppose I have following schema : DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, Phone) EMPLOYEE (EmployeeNumber ... trigger. Please help See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - SQL Command not properly ended?

I am using a SQL statement with a Temporary relation, and am getting the error ORA-009933: SQL command not ... Employees E) AS Temp; Thanks See Question&Answers more detail:os...

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

0 votes

930 views

1 answer

oracle - SQL Fiddle Output Error

Actually I am quite new to PL/SQL I created the following table using oracle pl/sql in SQL Fiddle create ... not able to display dbms_output? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - Spring Batch ORA-08177: can't serialize access for this transaction when running single job, SERIALIZED isolation level

I am getting this exception with SERIALIZED isolation level on JobRepository in Spring Batch: org.springframework.dao. ... of this exception? See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

oracle - NLS_LANG setting for JDBC thin driver?

I am using the thin Oracle JDBC driver ver 10.2.0 (ojdbc14.jar). I would like to configure its ... but this seems unelegant and unefficient. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Create an Excel File (.xlsx) using PL/SQL

In relation to my previous question Return the SQL Statement of an Explicit Cursor, i was able to generate an Excel (. ... .2.0.4.0 - Production See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - What does the colon sign ":" do in a SQL query?

What does : stand for in a query? INSERT INTO MyTable (ID) VALUES (:myId) How does it fetch the desired value? ... but what's the name for :? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - SQL - How to select a row having a column with max value

date value 18/5/2010, 1 pm 40 18/5/2010, 2 pm 20 18/5/2010, 3 pm 60 18/5/2010, 4 pm 30 18/5/2010, 5 pm ... that day(i.e 18/5/2010, 3 pm -> 60) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Number of rows affected by an UPDATE in PL/SQL

I have a PL/SQL function (running on Oracle 10g) in which I update some rows. Is there a way to find out how ... to get that number in PL/SQL. See Question&Answers more detail:os...

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

0 votes

835 views

1 answer

oracle - SQL selecting rows by most recent date with two unique columns

Using the following query and results, I'm looking for the most recent entry where the ChargeId and ChargeType are unique. ... 2 161 N 2/1/2008 See Question&Answers more detail:os...

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

0 votes

777 views

1 answer

oracle - Are foreign keys really necessary in a database design?

As far as I know, foreign keys (FK) are used to aid the programmer to manipulate data in the correct way. ... keys? Am I missing something here? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - NLS_NUMERIC_CHARACTERS setting for decimal

I have one db setup in a test machine and second in production machine. When I run: select to_number('100, ... for the decimal setting? Cheers! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Sql*plus always returns exit code 0?

Whenever I run a sql script using Sql*plus and check for $?, I get 0 even when the script wasn't succesful. ... occurs. How can I achieve that ? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - ORA-06508: PL/SQL: could not find program unit being called

I am using oracle 10g and toad 11.5. I am trying to call an api from an anonymous block. If I ... configurations in toad or database level. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags