Recent questions tagged oracle

0 votes

1 answer 1.0k views

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

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

0 votes

1 answer 1.2k views

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

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

0 votes

1 answer 991 views

oracle - How to handle optional parameters in SQL query?

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

0 votes

1 answer 961 views

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

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

0 votes

1 answer 902 views

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

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

0 votes

1 answer 971 views

oracle - Escaping single quote in PLSQL

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

0 votes

1 answer 1.2k views

oracle - Base 36 to Base 10 conversion using SQL only

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

0 votes

1 answer 1.1k views

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

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

0 votes

1 answer 1.1k views

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

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

0 votes

1 answer 905 views

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

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

0 votes

1 answer 921 views

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

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

0 votes

1 answer 937 views

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

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

0 votes

1 answer 916 views

oracle - Find out the history of SQL queries

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

0 votes

1 answer 875 views

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

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

0 votes

1 answer 728 views

oracle - Trigger to enforce M-M relationship

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

0 votes

1 answer 934 views

oracle - SQL Command not properly ended?

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

0 votes

1 answer 848 views

oracle - SQL Fiddle Output Error

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

0 votes

1 answer 1.2k views

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

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

0 votes

1 answer 1.6k views

oracle - NLS_LANG setting for JDBC thin driver?

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

0 votes

1 answer 1.0k views

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

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

0 votes

1 answer 969 views

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

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

0 votes

1 answer 982 views

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

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

0 votes

1 answer 999 views

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

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

0 votes

1 answer 760 views

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

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

0 votes

1 answer 718 views

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

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

0 votes

1 answer 1.1k views

oracle - NLS_NUMERIC_CHARACTERS setting for decimal

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

0 votes

1 answer 969 views

oracle - Sql*plus always returns exit code 0?

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

0 votes

1 answer 1.0k views

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

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

Categories

Just Browsing Browsing

Most popular tags