Lukket

Oracle Query Fix Oracle PLS-00428: an INTO clause is expected in this SELECT statement

I need help fixing this Oracle query.

See query attached and db structure.. I WILL NOT ALLOW REMOTE CONNECTION!!

You must have Oracle to test on your end or be amazing at debugging. I can always test on my end and let you know what errors I receive.

Færdigheder: Programmering af database, Oracle, SQL

Se mere: compare result select statements oracle, comparing select statements oracle, compare select statements oracle, sql compare select statements oracle, compare results select statements oracle sql, oracle select statement display column, fix unknown column products_id clause, display decimal points sql select statement, excel web query fix data position, insert select statement mysql, typing sql select statement, google mysql select statement insert, select statement insert statement mysql, oracle labeling column select statement, write sql select statement increase salary

Om arbejdsgiveren:
( 6 bedømmelser ) Cincinnati, United States

Projekt-ID: #15042678

54 freelancers are bidding on average $24 for this job

truongnguyen86

Hi there, i've faced into statement errors before, that's because of in Oracle function or procedure, you could not return result set as select statement like in SQL server, you use cursor to return Relevant Skills Mere

$35 USD in 0 dage
(155 bedømmelser)
6.5
fanninson45

I can solve this for you. However, the attached png document is not providing full information. You need send the full query statement Relevant Skills and Experience I highly value professionalism and hold myself stri Mere

$30 USD på 1 dag
(16 bedømmelser)
5.5
jagdishbhatt38

I have more than 8 years of experience in IT industry.I have worked on .net(c#net,vb.net,asp,asp.net,mvc) with SQLSERVER 2005/2008/2012/2014/2016 and ORACLE(pl/sql).I can provide you best solution. Relevant Skills and Mere

$30 USD in 10 dage
(25 bedømmelser)
4.7
vinaysinghh

. Relevant Skills and Experience . Proposed Milestones $15 USD - /

$15 USD på 1 dag
(36 bedømmelser)
4.9
GeraldoViana

You build an Anonymous Block to run SQL. You must use explicit cursors or provide the INTO list to your SQL, and create an Exception handler, for NOT DATA FOUND and TOO MANY ROWS. Relevant Skills and Experience This A Mere

$30 USD på 1 dag
(3 bedømmelser)
4.2
ref2

Please share complete query, I will try it on my database Relevant Skills and Experience 17 years of experience in oracle app development 25 certified oracle trainings 4 years degree in computer science Proposed Mile Mere

$25 USD på 1 dag
(23 bedømmelser)
4.3
shahzaib121

Hi Dear i have a lot of experience in Different kind of Databases. Currently, I am working as senior Database Consultant at private Company. Relevant Skills and Experience I have experience to work with every kind of Mere

$25 USD in 2 dage
(20 bedømmelser)
4.6
bmartynvw

Hi, My name is Benjamin. I'm an expert with over 14 years of experience on Oracle. Would love to help on this. Relevant Skills and Experience Expert level technical skills Can fix the issue quickly Proposed Mileston Mere

$32 USD på 1 dag
(9 bedømmelser)
4.1
enterpriseit1

your query is not complete from the image you sent. i see you are writing a stored procedure. Are you trying to get a output from the stored procedure that you are writing? let me fix this. Relevant Skills and Experi Mere

$30 USD in 0 dage
(4 bedømmelser)
3.8
$72 USD in 0 dage
(5 bedømmelser)
3.5
bhupen2606

Hi, i know what the issue is and can be fixed quickly without connecting to your server. Let me have a look at procedure text and i'll help you resolve the issue now. Relevant Skills and Experience SQL, PL/SQL, Oracle Mere

$25 USD på 1 dag
(8 bedømmelser)
2.8
AntonBliznetc

you need debug sql procedure in oracle db Relevant Skills and Experience I use Delphi & SQL for Account, CRM, ERP task form 1996 year. I am a full time programmer with 20 year exp in Russia. I have hi degree i Mere

$10 USD in 0 dage
(6 bedømmelser)
2.1
nbeslie

Hi, I am interested to work in your project. Please contact me for the details. Relevant Skills and Experience -2 years of experience in ORACLE DBMS -5 years of experience in (full-stack)web-development -Bachelor degr Mere

$15 USD på 1 dag
(3 bedømmelser)
2.0
ellenutza

Hello, My name is Elena and I am an Oracle Developer. I can help you with your project. I hope I will hear from you soon. Best regards, Elena Aptitudini și experiență relevante 8 years in Oracle development SQL and Mere

$15 USD in 0 dage
(3 bedømmelser)
1.7
JawadIT

Easy project to do. I can do it in 15 mins Relevant Skills and Experience Easy project to do. I can do it in 15 mins Stay tuned, I'm still working on this proposal.

$30 USD på 1 dag
(2 bedømmelser)
1.8
perfectdone

Send me complete stored procedure and I will solve it for you. Thanks :) Relevant Skills and Experience sql , oracle , plsql Proposed Milestones $30 USD - fix

$30 USD in 2 dage
(4 bedømmelser)
1.6
pratik123

Hi Allow me to do this job for you. I am currently residing in NJ, USA. So I will be available in your time as well . Hoping to see a long term work. Relevant Skills and Experience pl/sql Proposed Milestones $35 USD Mere

$35 USD på 1 dag
(1 bedømmelse)
0.9
consultkasyap

You need add collection variable along with INTO clause Relevant Skills and Experience Yes, Oracle PLSQL Developer Associate Certification from Oracle, 10+ yrs exp Proposed Milestones $20 USD - Fix the code and rever Mere

$20 USD på 1 dag
(0 bedømmelser)
0.0
Sunil1985

I am interested on this project Relevant Skills and Experience Yes Proposed Milestones $14 USD - hi

$14 USD på 1 dag
(0 bedømmelser)
0.0
charlyluis

Me envías el PL/Sql con la estructura de la base de datos , solo estructura , la corrijo y te la envió de vuelta. Stay tuned, I'm still working on this proposal.

$10 USD in 2 dage
(0 bedømmelser)
0.0