Recent questions tagged Oracle

0 votes

1.3k views

1 answer

oracle - SQL Error: ORA-00933: SQL command not properly ended

I am trying to update a record in oracle SQL developer by using Joins. Following is my query- UPDATE ... the error reason and solution See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - SQL error "ORA-01722: invalid number"

A very easy one for someone, The following insert is giving me the ORA-01722: invalid number why? INSERT INTO ... Knox','0418 418 347'); See Question&Answers more detail:os...

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

0 votes

831 views

1 answer

oracle - Spool Command: Do not output SQL statement to file

I am wanting to output a Query to a CSV file and am using the below as a small test; spool c:est. ... an running as script. Thanks Bruce See Question&Answers more detail:os...

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

0 votes

771 views

1 answer

oracle - creating parameterized views in oracle11g

I have a big query with nesting and left join and Ineed to create a view out of it so as not to run ... d.dateInRange order by d.dateInRange asc See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

oracle - SQL Error: ORA-01861: literal does not match format string 01861

I am trying to insert data into an existing table and keep receiving an error. INSERT INTO Patient ( ... help will be greatly appreciated! See Question&Answers more detail:os...

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

0 votes

850 views

1 answer

oracle - Business Logic: Database or Application Layer

The age old question. Where should you put your business logic, in the database as stored procedures ( or ... independence is not a goal. See Question&Answers more detail:os...

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

0 votes

848 views

1 answer

oracle - Deploying and Configuring ODP.NET to work without installation with Entity Framework

How do you deploy and configure ODP.NET to work without installation with Entity Framework? A. How to deploy ... install for designer support? See Question&Answers more detail:os...

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

0 votes

857 views

1 answer

oracle - Can We use threading in PL/SQL?

Is there any feature of asynchronous calling in PL/SQL? Suppose I am in a block of code would like to ... before executing(101,200) Thanks. See Question&Answers more detail:os...

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

0 votes

917 views

1 answer

oracle - SQL*Plus how to accept text variable from prompt?

Im very beginner in psql and i have a question. Here is the code: SET serveroutput ON ACCEPT myVariable ... SQL compilation error. *Action: 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-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ... and was able to accessed it. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

oracle - Splitting comma separated string in a PL/SQL stored proc

I've CSV string 100.01,200.02,300.03 which I need to pass to a PL/SQL stored procedure in Oracle. Inside ... know how to achieve this? Thanks. 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-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying

When I try to query objects, I end up with following error: ORA-01461: can bind a LONG value only for ... cause and solution of the problem? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags