I’m testing my ignite cache, inserting a simple User in the cache and then through a query I get the User entered previously returned I have a problem writing the query. I noticed that writing like …
Tag: sql
The Microsoft Access Database Engine Does not Recognize ‘[tbl_AssignmentDetails].[Position Name]’ as a valid field name or expression
I have created the below crosstab query off a find duplicates query. When I run it, I get the error message: “The Microsoft Access database engine does not recognize ‘[tbl_AssignmentDetails].[Position Name]’ as a valid field name or expression.” Any clues? Answer .. FROM [tbl_Assignmen…
Pass date string as variable in spark sql
I am unable to pass a date string in spark sql When I run this However I get error when I want to pass the date string as variable I am not sure, how to pass that variable. Answer you can just add single quotes to the query and it should work for you
ERROR: syntax error at or near “.” LINE 4: ON like.takerId = frame.likeId;
i have a table whose name is like. But whenever i have to select data from like, i was getting this error, i figured it out public.like..but when i try to join two tables i get this error i also use public prefix but it throws even if it is saying column like.takerid does not exist , then why it
VBA & SQL how to select specific values based on range in excel?
I am newbie in connection of vba (excel) and oracle database. I have tried to look for some information but I could not find anything that would work for me. I want to write a query that will return me only rows in which there is a specific values. My query looks like this: SQLStr = SQLStr = “SELECT NGK…
Could a SELECT inside of a transaction lock the table?
I would like to know if it’s possible that a select is blocking a table if it’s inside a transaction. It’s something like this: It’s a dummy example, but if there’s a lot of records in that table, and an API is receiving a lot of requests and calling this stored procedure, could …
Trying to join two tables together to have the unit_price vary based on the day
I have some code drafted but I’m not sure how to finish it, or if it needs more work. It looks like this. Everything looks good, but how do I get the price to be based on the given effective date? The given effective date is 01/01/2021. I was thinking something maybe like this for the where: I’m n…
Oracle SQL ternary operator or function?
Is there a simple Oracle syntax like a ternary operator or function? These work: If there’s a simpler, shorter syntax I would like to know. Answer You can use a CASE expression with LIKE: or DECODE and INSTR: or just simply use LIKE: INSTR: or REGEXP_LIKE: db<>fiddle here
How to create a stored procedure that will update a table
I am trying to create a stored procedure that will update the project status from ‘D’ to ‘C’. As you can see below I do not know what I am doing. Please do not suggest using a trigger as that does not pertain to the question. These are the errors I get when I run this code block: Error…
Why do not display values that I have entered in a database table?
Good evening. I have created a database with ORACLE SQL Developer and am having a small problem. In the RENTING table that I have created something like this: I am trying to enter the following data: cAFM = 10001, vPlateNumber = ‘XKO5434’, OutDate = ’13 / 07/2020 09:30 ‘, InDate = R…