Recent questions tagged oracle

0 votes

1.1k 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: -1 at org.hibernate.dialect.TypeNames.get( ... error in List li = qu.list(); line. See Question&Answers more detail:os...

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

0 votes

614 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) Example 2: select count(*) from my ... get different results by changing precedence with the OR test? See Question&Answers more detail:os...

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

0 votes

817 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 names and the table names used in it. I ... (); } Thanks in 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

880 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 tried in the SQL*Plus prompt the ... .SERVICE_UPDATE", line 27 ORA-06512: at line 1 See Question&Answers more detail:os...

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

0 votes

582 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 both point to the same database server ... strange looking I would appreciate any help, Thanks, Aidin See Question&Answers more detail:os...

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

0 votes

908 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 = " Select c1, c2, c3, rowid From ... is to an oracle v8 database Any help would be appreciated See Question&Answers more detail:os...

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

0 votes

620 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 reading those environment variables, but I'm ... server itself, which is what I do not want. See Question&Answers more detail:os...

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

0 votes

1.3k 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 value error: raw variable length too ... which is longer than 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

805 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 length(myvar) from table, but I can't do ... hope you can help me with this problem. thanks for advanced See Question&Answers more detail:os...

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

0 votes

767 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 are being displayed as 3, 5, 2 etc ... I force oracle to always show the decimal places? Thanks See Question&Answers more detail:os...

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

0 votes

613 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 the directory and but when I tried to ... to the next one. Is it possible to do that? See Question&Answers more detail:os...

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

0 votes

850 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 idea why. SELECT LAST_NAME AS "Last ... EMPLOYEES GROUP BY DEPARTMENT_ID, SALARY ORDER BY DEPARTMENT_ID); See Question&Answers more detail:os...

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

0 votes

653 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 Java Array to PLSQL stored procedure. conn = ... 11g, java 6 and I had tried ojdbc14 and ojdbc6. See Question&Answers more detail:os...

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

0 votes

639 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 sold, and whether the drug is a ... varchar2(15), RX_num varchar2(20), "date" date); See Question&Answers more detail:os...

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

0 votes

848 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: Encountered the symbol "SELECT" when expecting ... the entire table, so no optimization suggestions please See Question&Answers more detail:os...

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

0 votes

801 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 to group them by day. What Im ... identifier (stops on the group by). Any help? :D See Question&Answers more detail:os...

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

0 votes

939 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 status = 'S' order by creation_data asc ) ... That is why I tried rownum for that. Thanks. See Question&Answers more detail:os...

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

0 votes

599 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 TYPE businessTableForCategories AS TABLE OF ... groupings) into the nested table "businesses". See Question&Answers more detail:os...

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

0 votes

825 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.04. Then converted rpm packages to deb ... enabled or maybe it is a permissions problem? Thanks See Question&Answers more detail:os...

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

0 votes

687 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. This question is ... procedure_name='NEW_PROC'; no rows selected SQL> See Question&Answers more detail:os...

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

0 votes

799 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 Plugguble Database(PDB) using DBCA. I am ... Register PDB with my listener with port 1522?? See Question&Answers more detail:os...

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

0 votes

604 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 such problem when executing select * from joe.brunch May i know what is the issue here? See Question&Answers more detail:os...

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

0 votes

706 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 20101204 20101205 .. .. .. .. .. .. . ... = B.DATE order by EACH_DATE ASC ) emphasized text See Question&Answers more detail:os...

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

0 votes

622 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 define a cursor. The cursor will ... INTO v_thing; END LOOP; CLOSE get_records; END; See Question&Answers more detail:os...

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

0 votes

744 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 that contains a VARCHAR(4000) field as ... allow that value to be stored in that column? See Question&Answers more detail:os...

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

0 votes

633 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 of it here for business reasons. The ... the wrapping of the cursor contents in 4.0? See Question&Answers more detail:os...

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

0 votes

670 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 link3 WHERE invoice_num =" & request. ... ended What would be the right syntax for this? See Question&Answers more detail:os...

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

0 votes

821 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 but I think there's some syntactical mistake ... ); END LOOP; dbms_output.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