Recent questions tagged Oracle

0 votes

1.1k views

1 answer

oracle - ORA-00933: SQL command not properly ended

I'm using OLEDB provider for ADO.Net connecting to an Oracle database. In my loop, I am doing an insert: ... ended What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - ORA-01036: illegal variable name/number when running query through C#

I am trying to use ALTER USER query for Oracle database using OracleCommand in C# in the following code. It ... wrong with my implementation?. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Run SCRIPT from PL/SQL Block

How to use "START SCRIPT" in pl/sql block ? I want to use something like this declare begin proc(para1,para2 ... operations in the PL/SQL block. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - How to add ojdbc7 to Java web app by Gradle?

My context: I build a Java web application what based on Spring Boot 1.3.5.RELEASE . I try to add ... dependencies list by Gradle, thank you! See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - ORA-02287: sequence number not allowed here

I am trying to select values from two tables and insert them into one table and calculate the number of ... placement_two group by year); See Question&Answers more detail:os...

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

0 votes

921 views

1 answer

oracle - Python module "cx_Oracle" module could not be found

I recently installed cx_Oracle module on my machine, in order to connect to a remote Oracle database server. (I ... me out? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

oracle - SQL not displaying null values on a not equals query?

This is just a question out of curiosity but I am looking at a database and pulling data from a table ... commands through Oracle SQL Developer. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - SQL Error: ORA-02291: integrity constraint

I am creating a database that is trying to access values from a foreign key. I have created two following tables ... so far in Oracle SQL dev See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle SQL how to remove time from date

I have a column named StartDate containing a date in this format: 03-03-2012 15:22 What I need is to ... : the PA_VALUE column is: VARCHAR2 See Question&Answers more detail:os...

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

0 votes

898 views

1 answer

oracle - How to check if a column exists before adding it to an existing table in PL/SQL?

How do I add a simple check before adding a column to a table for an oracle db? I've included the ... .tablename ADD columnname NVARCHAR2(30); See Question&Answers more detail:os...

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

0 votes

981 views

1 answer

oracle - SQL Error: ORA-00942 table or view does not exist

I use SQL developer and i made a connection to my database with the system user, after I created a user and made ... ('1','Micheal','Jackson') See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - PL/SQL block problem: No data found error

SET SERVEROUTPUT ON DECLARE v_student_id NUMBER := &sv_student_id; v_section_id NUMBER := 89; v_final_grade NUMBER; ... the case flow. See Question&Answers more detail:os...

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

0 votes

856 views

1 answer

oracle - How can I issue a single command from the command line through sql plus?

Using SQL Plus, you can run a script with the "@" operator from the command line, as in: c:>sqlplus username/ ... of two-line ".sql" files. See Question&Answers more detail:os...

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

0 votes

985 views

1 answer

oracle plsql: how to parse XML and insert into table

How to load a nested xml file into database table ? <?xml version="1.0" ?> <person> <row> <name>Tom</name> ... 's the best solution to do this ? See Question&Answers more detail:os...

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

0 votes

952 views

1 answer

oracle - BEGIN - END block atomic transactions in PL/SQL

This information should be easy to find, but I haven't had any luck. When I have a BEGIN - END block in a ... using an implicit block, I think. See Question&Answers more detail:os...

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

0 votes

982 views

1 answer

oracle - Difference between LockModeType Jpa

I am confused about the working of LockModeTypes in JPA: LockModeType.Optimistic it increments the version while ... no wait is there? See Question&Answers more detail:os...

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

0 votes

901 views

1 answer

oracle - What is the difference between precision and scale?

What is the difference between precision and scale in Oracle? In tutorials they usually leave scale empty and set ... and scale stand for? See Question&Answers more detail:os...

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

0 votes

989 views

1 answer

oracle - Create Pivot view in SQL from a SQL table

I have the following table TEMP I want to create a pivot view using SQL, Ordered by CATEGORY ASC ,by LEVEL DESC ... in the db in this format. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - passing in table name as plsql parameter

I want to write a function to return the row count of a table whose name is passed in as a variable. Here's ... 'm not sure how to escape that. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle "table or view does not exist" from inside stored procedure

the scenarion is like this... I HAVE a namespace XXX where I created some tables and some stored procedures... ... I check anything else??? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - PL/SQL comma delimited list; remove dups and put in array

I have a comma delimited list as a string in a PL/SQL procedure. I need to Remove duplicates Put the list in ... , just not both. Any help? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - ORA-04091: table [blah] is mutating, trigger/function may not see it

I recently started working on a large complex application, and I've just been assigned a bug due to this error: ... this trigger work. Is there? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

oracle - ORA-12704: character set mismatch

Hell when I do: select COALESCE (CORP_ID, 0) from crmuser.accounts; The CORP_ID records which are Null returns ... do to return default Values? See Question&Answers more detail:os...

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

0 votes

971 views

1 answer

oracle - How to use parameters in a 'where value in...' clause?

This works when I have only one state code as a parameter. How can I get code to work when I have ... get_record.state_code); end loop; END; See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

oracle - Reading clob line by line with plsql

In my project i use oracle as primary database and i've faced a problem with parsing clob. So suppose we ... . Is there any possible solutions? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

oracle - Get the LENGTH of a LONG RAW

I have a table with a column of data type LONG RAW. How do I determine the size (in bytes) of the ... some old software that might require it) See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

oracle - Getting Error - ORA-01858: a non-numeric character was found where a numeric was expected

I am getting the error in the below sql: ORA-01858: a non-numeric character was found where a numeric was ... c GROUP BY c.contract_num; See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

oracle - Cursor For Loop with dynamic SQL-Statement

Is there a way to perform a Cursor For Loop with an dynamic SQL-statement? If I don't want to declare a ... it with an "undeclared" record? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags