So I`m trying to make a statistic view which counts various things like how many users are in table called “PACIENTAS” , how many doctors are in table “GYDYTOJAS” and it works. CREATE OR REPLACE …
Tag: oracle
ORA-01873 when calculating the difference between two timestamps
I am trying to produce the number of days between two timestamps, as a precise fractional number. My code is producing ORA-01873: the leading precision of the interval is too small This single line …
ORACLE CREATE TABLE with FOREIGN KEY error
I am a beginner to Oracle and have been having problems creating a table with a foreign key, I have created the parent table region as well and have been receiving the same error. I have researched on W3school and used the same syntax but still no help. Answer Leave “FOREIGN KEY” out, if you want …
APEX get Multiple entries FK
,i dont know what so search for my problem. I think its very simple, but i dont know about that 🙂 I have a Table where i listed all my “Groups/Teams” And then i have a Users Table where i list all the People: I use APEX 18.1 and have a Form with a List of Values, there i can
Problem in creating new table ORA-00906: missing left parenthesis
Here is my instruction : it works on my friend computer ! A ORA-00906: missing left parenthesis Any help ! Answer Please make sure all the “varchar” fields has a length defined. In your second table, it says: date_rdv VARCHAR NOT NULL, which I believe causing the issue, so try to change it into da…
Oracle – Is there a way to rewrite my query to lower the number of times I’m querying a table
My modified query: SELECT SLDOCO AS ORDER_NO, SLDCTO AS ORDER_TYPE, SLAN8 AS CUSTOMER_NO, ABALPH AS CUSTOMER_NAME, SLLTTR AS LAST_STATUS, SLNXTR AS …
How to set large string as param without getting ORA-01460: unimplemented or unreasonable conversion error?
In spring-boot using namedParameterJdbcTemplate (Oracle db version 12 and odbc8 driver 12.2) I am getting the following error while executing a SELECT query bound with a parameter larger than 4000 …
SQL Oracle – Replace function in Where Clause
I want to use the REPLACE function in the Where clause to replace a character that I put into a input box. For example if I input R123;R321 I want it to change my input to R123′,’R321. Example of my …
How do I use both a SELECT query and RETURNING inside the same SQLPLUS INSERT INTO statement
I’m working on this project I’m using sqlplus and I’m making this procedure in PL/SQL: I just get the error: SQL command not ended properly. I can’t find any information online about how to properly do this. I tried to have t_order_no as a table. I tried having it RETURNING BULK COLLEC…
SQL oracle: How can I get the results of 4 selects statements added & subtracted to get one value with a ‘WITH’ keyword
My code is: The result of each select statement in the with clause returns one value. I am trying to add the expenses and subtract it from the income. When I run the whole code I am getting some error which I am unable to figure out. Am I doing something wrong? I want the result from the aliases in