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 993 views

oracle - How to handle optional parameters in SQL query?

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

0 votes

1 answer 963 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 903 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 972 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 909 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 923 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 940 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 918 views

oracle - Find out the history of SQL queries

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

0 votes

1 answer 876 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 732 views

oracle - Trigger to enforce M-M relationship

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

0 votes

1 answer 938 views

oracle - SQL Command not properly ended?

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

0 votes

1 answer 850 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 970 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 985 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 1.0k 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 761 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 722 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 971 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)

0 votes

1 answer 1.3k views

oracle - SQL Error: ORA-00933: SQL command not properly ended

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

0 votes

1 answer 1.1k views

oracle - SQL error "ORA-01722: invalid number"

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

0 votes

1 answer 754 views

oracle - Spool Command: Do not output SQL statement to file

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

0 votes

1 answer 695 views

oracle - creating parameterized views in oracle11g

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

0 votes

1 answer 1.2k views

oracle - SQL Error: ORA-01861: literal does not match format string 01861

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

0 votes

1 answer 756 views

oracle - Business Logic: Database or Application Layer

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

0 votes

1 answer 779 views

oracle - Deploying and Configuring ODP.NET to work without installation with Entity Framework

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

Categories

Just Browsing Browsing

Most popular tags