Recent questions tagged ORACLE

0 votes

923 views

1 answer

recently, while working on a db2 -> oracle migration project, we came across this situation. the developers were ... Oracle built-in type ? See Question&Answers more detail:os...

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

0 votes

844 views

1 answer

oracle - how to do connection pooling in java?

I am trying to understand connection pooling in java, i am using jsp, servlet and tomcat 6 server in my ... tomcat server or something else? See Question&Answers more detail:os...

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

0 votes

981 views

1 answer

oracle - Executing a dynamic sql statement into a SYS_REFCURSOR

is it possible to execute a dynamic piece of sql within plsql and return the results into a sys_refcursor? ... apreciated. Thanks Again Jon See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - ORA-00604 ORA-12705

I am having this error in my j2ee web application. java.sql.SQLException: ORA-00604: error occurred at recursive ... t have any problem with it See Question&Answers more detail:os...

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

0 votes

837 views

1 answer

oracle - SQL: how to use UNION and order by a specific select?

I have two selects: SELECT id FROM a -- returns 1,4,2,3 UNION SELECT id FROM b -- returns 2,1 I'm receiving ... I do this? (I'm using Oracle) See Question&Answers more detail:os...

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

0 votes

865 views

1 answer

oracle - How come sqlplus not connecting?

My goal is to connect to an Oracle 9i instance from my OS X machine. I've followed the setup instructions here ... sure why mine wasn't working. See Question&Answers more detail:os...

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

0 votes

828 views

1 answer

oracle - Inventory Average Cost Calculation in SQL

I want to compute inventory costs using average value, and I'm somewhat stuck here... Consider a simple transaction ... here, but it cant hurt. See Question&Answers more detail:os...

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

0 votes

821 views

1 answer

oracle - PL/SQL Performance Tuning for LIKE '%...%' Wildcard Queries

We're using Oracle 11g database. As you may or may not know, if you use wildcard query with "%" in front of ... , so please do keep them coming. See Question&Answers more detail:os...

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

0 votes

965 views

1 answer

oracle - Removing leading zeros from varchar sql developer

How would I remove the leading zeros from a number which is in the form of varchar. I have tried the following: ... that? Thanks for any help! See Question&Answers more detail:os...

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

0 votes

958 views

1 answer

oracle - SQL: delete all the data from all available tables

I am using oracle DB to maintain more than 30 tables, how can I delete all the data from all the tables? I ... the data but not drop the tables. See Question&Answers more detail:os...

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

0 votes

958 views

1 answer

oracle - Table function with bulk collection throws invalid datatype

I am writing a function and i want to wrap it with table function so i can use with select query. Here ... doing wrong here? Thanks in advance See Question&Answers more detail:os...

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

0 votes

958 views

1 answer

oracle - SQL: How to find duplicates based on two fields?

I have rows in an Oracle database table which should be unique for a combination of two fields but the unique ... /or how to solve this? See Question&Answers more detail:os...

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

0 votes

881 views

1 answer

oracle - Java - find the first cause of an exception

I need to check if an exception is caused by some database problem. I receive an Exception and check if its cause ... else { return null; } } See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - What can cause intermittent ORA-12519 (TNS: no appropriate handler found) errors

We are running our Junit 4 test suite against Weblogic 9 in front of an Oracle 10 database (using Hudson as a ... with no issues. Any ideas? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - Issues calling stored procedure from C# with large CLOB

I'm not the first to have these issues, and will list some reference posts below, but am still looking for ... /extending the PL/SQL routines. See Question&Answers more detail:os...

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

0 votes

771 views

1 answer

oracle - How to call procedure with out parameter as table type from a Java class

I want to call this procedure get_data_Q1 in the package ult_pkg from Java code and display the output: CREATE ... get_data_Q1; end ult_pkg; / See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - How do I exit a script in SQLPlus when an error occurs and return to the SQLPlus prompt, without disconnecting or exiting SQLPlus?

I have some scripts that get run often, always from within a connected SQLPlus session. I need a way to ... which is not acceptable behavior. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - What's the difference between pls_integer and binary_integer?

I've inherited some code which is going to be the base for some additional work. Looking at the stored procs, ... ? I'm using Oracle 10gR2 See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - ORA-01031: insufficient privileges when selecting view

When I try to execute a view that includes tables from different schemas an ORA-001031 Insufficient privileges is thrown ... What am I missing? See Question&Answers more detail:os...

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

0 votes

958 views

1 answer

oracle - How do I pass arguments to a PL/SQL script on command line with SQLPLUS?

How do I pass arguments to a PL/SQL script on command line with SQLPLUS? I can call my PL/SQL script like ... the SQL*Plus "START" command? See Question&Answers more detail:os...

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

0 votes

944 views

1 answer

oracle - Are circular references acceptable in database?

When are circular references acceptable in database? Theoretical and practical, any help is appreciated. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Taking the record with the max date

Let's assume I extract some set of data. i.e. SELECT A, date FROM table I want just the record with ... using ANALYTIC FUNCTION to do the same? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - Truncating a table in a stored procedure

When I run the following in an Oracle shell it works fine truncate table table_name But when I try to put it in a stored ... ( or . or ; := Why? See Question&Answers more detail:os...

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

0 votes

897 views

1 answer

oracle - How do I use CREATE OR REPLACE?

Am I correct in understanding that CREATE OR REPLACE basically means "if the object exists, drop it, then ... documentation about this syntax. See Question&Answers more detail:os...

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

0 votes

873 views

1 answer

oracle - Search a value in the column value that stores comma separated values

Suppose I have table XYZ with a column Weekend_Days which stores the value, SUNDAY,SATURDAY and I have another table ABC ... -16 0 06-Feb-16 1 See Question&Answers more detail:os...

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

0 votes

926 views

1 answer

oracle - Oracle10g SQL pivot

I have a table named TABLE for example looking like: ID | email -------------- 1 | [email protected] 1 | ... Edit: fixed above thanks to beach's answer See Question&Answers more detail:os...

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

0 votes

770 views

1 answer

oracle - is there any function for translating data in sql

I want to convert the data in one of my columns to another language ... is there any function in sql for translating it? See Question&Answers more detail:os...

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

0 votes

863 views

1 answer

oracle - Java Multicast Time To Live is always 0

I have a problem with setting the TTL on my Datagram packets. I am calling the setTTL(...) method on the packet ... TTL field is always set to 0 See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags