Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

Recent questions tagged oracle

0 votes
657 views
1 answer
    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
352 views
1 answer
    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
514 views
1 answer
    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
550 views
1 answer
    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
315 views
1 answer
    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
628 views
1 answer
    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
426 views
1 answer
    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
930 views
1 answer
    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
483 views
1 answer
    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
455 views
1 answer
    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
336 views
1 answer
    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
523 views
1 answer
    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
411 views
1 answer
    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
361 views
1 answer
    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
538 views
1 answer
    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
480 views
1 answer
    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
617 views
1 answer
    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
323 views
1 answer
    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
467 views
1 answer
    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
397 views
1 answer
    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
576 views
1 answer
    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
400 views
1 answer
    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
448 views
1 answer
    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
358 views
1 answer
    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
447 views
1 answer
    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
382 views
1 answer
    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
442 views
1 answer
    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
479 views
1 answer
    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)
Ask a question:
Welcome to Jonic Developer Community for programmer and developer-Open, Learning and Share
...