I have timestamp date format in column FIRST_DATE and i need to choose time period from a certain hour, for ex. all from 18:00 10.05.21 to 18:00 11.05.2021 the problem is that date column in timestamp format – FIRST_DATE: 10/05/2020 0:00:03,000000 TIMESTAMP(6) so i tried to use it: so with this way i wa…
Tag: oracle-sqldeveloper
SQL Oracle: Save variable from select with where statement
i’m using SQL Developer 19.1. I have a huge script with multiple subselect statements. It looks like this i want to get var1 and var2 with a another select statements. How do i do that? i tried but it seems like i cant use a where statement there. i also tried something with bind or @var1.. Do you guys …
Right error missing parenthesis error, Where is the placement at?
Why does the query produce an right parenthesis: Error report – ORA-00907: missing right parenthesis 00907. 00000 – “missing right parenthesis” I have tried everything on where to put the right parenthesis and it is not working. Here is my code: Answer Add a comma after “Customer…
How is this cardinality being calculated in Explain plan?
I am analyzing the “explanation plan” about the following instruction and Oracle SQL Developer tells me that it has a cardinality of 1513 and cost of 1302. How are these calculations performed? Could be reproduced with an instruction (calculate with a select and obtain de same value)? Answer The c…
Revisting ORA-06576: not a valid function or procedure name for simple function call via various database tools
Revisting ORA-06576: not a valid function or procedure name for simple function call via dbeaver database-tool I have seen many posts, but they don’t cover the situation I am experiencing. I am trying to do a simple function call to Oracle SQL via dbeaver: According to the right-click call function obta…
Multiple tables joined to a table via single column
I am trying to create query, on below scenario. with my skills I am able to join Table A,A1,B and A,A1,C and A,A1,D individually and union them. Is there any better way to achieve same. I am using Oracle as Database. Answer It all depends on what they mean and if you need to know the columns the values are
SQL Statement to Return Records with More than Two Instances and Omit the Last Instance
I am looking to write a SQL statement that will pull EventIDs with two or more instances, but will omit the last instance of these records. This seems crazy, but the purpose of this is to look at events that have multiple updates (the updates are related to the TIME_OF_EVENT column, each time a crew/person up…
i am trying to combine the PL/SQL and the SQL commands in manipulating the database. am i doing it correctly? any help and corrections?
enter image description hereuse PL/SQL with SQL commands in manipulating the database (PL/SQL structure, Data types, Variable, DBMS Output and Conditions) and this is my codes and what i have understandenter image description here Answer The sample code for me does not run. It gives The reason is that you hav…
How can I evaluate the size for when it returns the value whatever I want?
I have this query in which I check with the NVL function if a field is null that it returns the other one and so on respectively, but I want to make sure that regardless of the data that it returns it is not greater than 10 and if it is, then that it cuts the string in that limit
How can i store results of a query in an array?
I have to store last 5 employees_id’s from employees table into an array. I made the query correct and i have the array, but i can’t understand the syntax to store the results in that array. Here’s my code and here’s my query How can i store the results from the query in the array? As …