Recent questions tagged Oracle

0 votes

2.6k views

1 answer

oracle - How to fix “No Dialect mapping for JDBC type: -1” error in java

i'm getting one error how to resolve this error i.e, org.hibernate.MappingException: No Dialect mapping for JDBC type: ... = qu.list(); line. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

oracle - In SQL, what does using parentheses with an OR mean?

Example: select count(*) from my table where column1 is not null and (column1 = 4 OR column1 = 5) ... changing precedence with the OR test? See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

oracle - Parsing table and column names from SQL/HQL Java

I am looking for an open source API in Java to parse an SQL / HQL query so that it gives me the column ... advance for any help in this regard. See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

oracle - dbms_output size buffer overflow

I tried to set the dbms_output size to unlimited inside a stored procedure. But it gave me compilation errors. So I ... 27 ORA-06512: at line 1 See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

oracle - How to install ODP.NET 2.111 and ODP.NET 4.112 in the same machine side-by-side while both point to the same database server

The question is how to install ODP.NET 2.111 and ODP.NET 4.112 in the same machine side-by-side while ... appreciate any help, Thanks, Aidin See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

oracle - ORA-01460: unimplemented or unreasonable conversion requested

When I run the following .Net code: using (var c = Shared.DataSources.BSS1.CreateCommand()) { c.CommandText ... Any help would be appreciated See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

oracle - Can SQL*Plus read environment variables from the machine is it running on?

I'm aware that the database engine itself is (often) on another machine and that SQL*Plus has no direct way of ... is what I do not want. See Question&Answers more detail:os...

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

0 votes

2.7k views

1 answer

oracle - How can I avoid "raw variable length too long" errors in SQL Developer?

I am updating a BLOB with large mount of text and I get this error: SQL Error: ORA-06502: PL/SQL: numeric or ... the text I am trying to insert. See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

oracle - convert blob to clob

I'm using oracle 11g and I'm trying to find out the length of a text. I will normally use select ... with this problem. thanks for advanced See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

oracle - Always show decimal places in SQL?

I'm working on a query which returns numeric values (currency). Some of the values are whole numbers and ... show the decimal places? Thanks See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

oracle - Make SQL*Plus script quit

I have a few SQL*Plus scripts in a directory that I would like to run automatically using powershell. I can read ... Is it possible to do that? See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

oracle - SQL Missing right parenthesis on order by statement

On the order by line, I get an error saying that it's missing a right parenthesis, but I have no ... , SALARY ORDER BY DEPARTMENT_ID); See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

oracle - Passing an array of Object from Java to PL/SQL function

I am trying to create a Java array (java.sql.Array) object using an array of objects. I need to pass this ... I had tried ojdbc14 and ojdbc6. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

oracle - SQL joining question

Here is my situation: I have one table that contains a list of drugs sold containing the NDC (an identifier), quantity ... (20), "date" date); See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

oracle - scalar subquery in if statement Condition in PL/SQL

I have an If Statement block similar to the below which is failing with the error - PLS-00103: ... so no optimization suggestions please See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

oracle - How to group by each day in PL/SQL?

Im trying to get statistics for each day with PL/SQL. Each day have several entries, bukkets of errors :-) I want ... group by). Any help? :D See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

oracle - How to solve ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY

I want to lock a group of records using the following query: select * from (select * from event_table where ... tried rownum for that. Thanks. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

oracle - How to insert a value into a nested table without losing data in that table?

How can I insert new data into an existing row's nested table? For example, I have defined CREATE OR REPLACE ... the nested table "businesses". See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

oracle - Error loading oci8.so with Ubuntu server 17.04 php 7 and apache2

I have gone through the whole process of downloading Oracle instant client, SDK, etc. in a Ubuntu Server 17 ... is a permissions problem? Thanks See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

oracle - ALL_PROCEDURES view doesn't show the PROCEDURE_NAME

Why can't I see my procedure in user_procedures view? Why is the procedure_name filter on all_procedures view returns ... no rows selected SQL> See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

oracle - How to Register Pluggable Database(PDB) with new created LISTENER

I am working with Oracle 19c in centos 7. After Oracle installation, i created new Container Database(CDB) with ... listener with port 1522?? See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

oracle - ORA-00942: Can select from "schema.table" but not "table"?

I experienced an ORA-00942 ("table or view does not exist") when executing select * from brunch However, no ... know what is the issue here? See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

oracle sql query to list all the dates of previous month

Guys i have a requirement to list all the dates of the previous month like below 20101201 20101202 20101203 ... EACH_DATE ASC ) emphasized text See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

oracle - Conditionally define a Cursor

I have a Procedure in Oracle that takes a varchar2 paramater. Based on the value of that parameter, I need to ... LOOP; CLOSE get_records; END; See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

oracle - If we have US7ASCII characterset why does it let us store non-ascii characters?

We have an Oracle database that has the NLS_CHARACTERSET = US7ASCII. As a test, we ran an insert into a table ... to be stored in that column? See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

oracle - SQL Developer script output truncates sys_refcursor width

I have a function defined that returns a sys_refcursor containing 5 text columns. Sorry, I cannot post the contents ... cursor contents in 4.0? See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

oracle - ASP Classic SQL Query error message, right syntax please

I am passing two (2) parameters in the URL, and building the following SQL: mQry = "SELECT DISTINCT name FROM ... be the right syntax for this? See Question&Answers more detail:os...

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

0 votes

2.2k views

1 answer

oracle - A procedure to Reverse a String in PL/SQL

I just started learning PL/SQL and I'm not sure how to create a procedure. The logic seems about right ... .put_line(reverse); END; / See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags