Welcome to OStack Knowledge Sharing 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
658 views
1 answer
    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
352 views
1 answer
    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
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 ... 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 ... 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 ... 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 ... Any help would be appreciated See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
427 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 ... 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 ... 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 ... with this problem. thanks for advanced See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
456 views
1 answer
    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
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 ... Is it possible to do that? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
524 views
1 answer
    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
412 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 ... 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 ... (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: ... so no optimization suggestions please See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
481 views
1 answer
    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
620 views
1 answer
    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
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 ... 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 ... 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 selected SQL> See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
577 views
1 answer
    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
400 views
1 answer
    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
449 views
1 answer
    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
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 ... 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 ... 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 ... cursor contents in 4.0? See Question&Answers more detail:os...
asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)
0 votes
443 views
1 answer
    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
481 views
1 answer
    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)
Ask a question:
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...