Skip to main content
100 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
35 views

This is the code: INSERT INTO Assignment (AssignmentID, EmployeeID, TaskID, StartDate, EndDate) VALUES (1, 27, 1, '2018-03-01', '2018-03-06'), (2, 10, 2, '2018-03-01', '2018-03-06'), ...
user24879491's user avatar
  • 1
1 vote
1 answer
491 views

I'm executing the following sql Alter USER test_user2 GRANT CONNECT THROUGH test_user1 ROLE myTestRole1; in Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 database and running in to the ...
mounish's user avatar
  • 13
0 votes
1 answer
2k views

I am trying to build a complex query, but I am not sure if I am structuring it right, as I am getting the error: ORA-00933: SQL command not properly ended. The error is happening at line 2. Please, ...
oana's user avatar
  • 83
0 votes
2 answers
76 views

I am learning SQL and can not figure out what I am doing wrong in my code. Select robot, city, country, count(sponsor.sponsor) From robot join sponsor on robot.robotid = sponsor.robotid ...
user avatar
0 votes
2 answers
577 views

Sorry if my question sounds dumb but I'm relatively new to coding especially in Oracle SQL Developer and really need help. I used to use mySQL. So I'm still a little confused. Here is my code: CREATE ...
nlnl's user avatar
  • 11
1 vote
0 answers
461 views

I have a SQL file and I'm trying to execute queries in it via PowerShell. But even I can execute one query, I can not when adding that file multiple queries like below. GRANT SELECT ON table TO user1; ...
user avatar
2 votes
0 answers
616 views

I have searched high and low for answers so apologies if it has already been answered! Using R I am trying to perform a lazy evaluation of Oracle 11.1 databases. I have used JDBC to facilitate the ...
Adam Pirsl's user avatar
  • 21
0 votes
4 answers
1k views

INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES (7499,'ALLEN','SALESMAN',7698,'20-Feb-81',1600,300,30) , (7521,'WARD','SALESMAN',7698,'22-Feb-81',1250,500,30); Tried to ...
beyou's user avatar
  • 15
1 vote
0 answers
262 views

When I try and run the following refresh for a MATERIALIZED VIEW ALTER materialized VIEW table_name.materialized_view_name refresh FORCE START WITH trunc(SYSDATE, 'HH24') + 2/24 NEXT SYSDATE + 6/24; ...
Krum Milanov's user avatar
  • 11
6 votes
2 answers
5k views

I have Oracle version 12.2.0.1.0 We have generic script which create sequence that need to be reuse for different objects (by renaming sequence name): CREATE SEQUENCE NAME_SEQ MINVALUE 1 MAXVALUE ...
Ori Marko's user avatar
  • 59.3k
0 votes
3 answers
2k views

When I run SELECT COUNT(*) INTO l_entry_found FROM hera.hera_user@iam WHERE username = docm.eb_key; without execute immediate it works. execute immediate' SELECT COUNT(*) INTO ...
Luca Frey's user avatar
  • 1
1 vote
4 answers
2k views

I'm trying to create new view from 2 different table of same schema. This is my query, let me know if I'm missing anything. When I check the syntax it is fine and test it, throws 00933 error. CREATE ...
Atchouda's user avatar
  • 11
0 votes
2 answers
599 views

So I'm trying to create a trigger that alters a records timestamp, I have this so far create or replace TRIGGER job_date_set AFTER INSERT OR UPDATE OF start_date, closing_date ON jobs ...
Zachary's user avatar
  • 65
0 votes
2 answers
770 views

I need to convert MSSQL query to Oracle but end up with SQL command not properly ended. Here is MSSQL query SELECT * FROM [dbo].[trade] AS [Extent1] WHERE EXISTS ( SELECT 1 AS [C1] FROM [dbo]...
aMerkuri's user avatar
  • 173
0 votes
2 answers
138 views

Oracle SQL: How to find and remove duplicates I have only read-only access to Oracle (Can use SELECT command only). Logic: Two users 'A' & 'B' are having same Company Name & First Name ...
AnchitPhoenix's user avatar
  • 19
1 vote
2 answers
4k views

I'm executing the following query: select count(*),ACTION_DATE from SUMMARY group by ACTION_DATE where NUM_ACTIONS=500; which is giving me ORA-00933 SQL Command not properly ended and I'm not sure ...
bbedward's user avatar
  • 6,488
0 votes
1 answer
107 views

So trying to update an empty column that I just created with the script below. Whenever I try to run it I get the following error message (Query 1): ORA-00933: SQL command not properly ended So I ...
Jesper 's user avatar
  • 1
-1 votes
1 answer
2k views

I am new to Oracle and experiencing this problem. I created a procedure like this: CREATE OR REPLACE PROCEDURE getArt as begin select ar.artTitle, ar.artContent, ar.DateCreated, ar.artCategory, ...
looooongname's user avatar
  • 117
0 votes
1 answer
147 views

I have the following codes: IF nvl(p_value, 0) >= 0 THEN l_currency_prefix := 'scc.currency_prefix_pos'; l_currency_suffix := 'scc.currency_suffix_pos'; ELSE l_currency_prefix ...
Law's user avatar
  • 349
3 votes
3 answers
33k views

I keep getting this error. How do I solve this problem? Error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended Code: <update id="updateProc" parameterClass="rating"&...
user3543466's user avatar
  • 31
1 vote
1 answer
3k views

I am trying to run the following code and I get an ORA-00933 error: <code> --CODE B select distinct po_details.po_id, po_details.po_det_id, po_details.change_order, po_details.start_date, ...
ValerieR's user avatar
  • 29
0 votes
2 answers
2k views

I hope receive my answer this time i wrote below code but don't know where is my mistake it seem correct i think this code should insert more than million records into oracle xe i wrote it by ...
sara 's user avatar
  • 1
1 vote
1 answer
1k views

I've isolated my problem down to this code, which is giving me the error message "ORA-00933: SQL command not properly ended" for the on duplicate key line. I'm trying to insert rows unless they have ...
stringy's user avatar
  • 1,363
0 votes
4 answers
2k views

I don't understand what is wrong with this query. It is giving me a compile time error of "command not ended properly". The inner query is giving me four records. select WGN3EVENTPARTICIPANT....
Amandeep's user avatar
  • 47
1 vote
3 answers
5k views

I am getting the sql command not properly ended when hiting this line below. stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); String updateQ = "update ...
Siti Haslina Mohd Zulkafli's user avatar
  • 27

1
2