I have this simple enough insert query but i have no idea why it is returning an error. i can see the error comes from the row Birthay, if i remove it the insert is done ok. My query: INSERT INTO …
Tag: oracle
Hackerrank SQL problem to solve in Oracle’s SQL version
Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest …
Oracle Apex update specific row of table
Hi i want to update a specific row of my oracle database via apex. So i need to reach/address the specific row via where clause. example entries: GATTUNG ART UNTERART ABART VARIETÄT AAA AAA AAA NULL …
Loop through JSON array in PLSQL 12.1
I have JSON array inside varchar DECLARE JsonArray varchar2(1000); arrayCars varchar2(1000); BEGIN JsonArray :={“Cars”: [{“name”:”Honda”, “color”:&…
sql oracle – select availability between dates
I have the below table INDISPONIBILITY, that respresents the availability of teachers, for example the teacher a1 is not available from 25-Jan-21 to 25-Jan-21 from 8:00 to 12:00. I want to select …
Oracle DB sql group the table_names patterns into a group
I am trying to classify certain patterns of tables in individual groups and display the results this is fine i included a case statements and classified it but how to group the counts , let provide the sql logic and existing results and expected results so that it will be understood. database is Oracle 11g SQ…
How to ungroup the grouped record based on count column using SQL
I have below data set obtained after group by dept and loc. dept id loc count 100 a 2 300 c 1 I need out put like below deptid loc 100 a 100 a 300 c please help Answer Another option is to use Recursive Queries to get the desired result. DB Fiddle Link: https://dbfiddle.uk/?rdbms=oracle_18&fiddle=0580680e…
Oracle sql | Share generated by default on null as identity
Is it possible to share the same “pool” for ids when using following syntax? When both attribute have the same name? The only possibility I came up was to start both at different values. Like Test on 1000 and test 2 on 2000 but this is not a long term solution. I’m looking to a solution wher…
ORA-00907: Missing Right Parenthesis on a left join of two subqueries
It’s been a little while since I’ve messed with SQL and I’m picking it back up for a course. I need to create a table of table name, column name, constraint name, and constraint type for all tables with my user, but every time I try, I’m getting a missing right parenthesis error. Here&…
How to access a table with username with special characters in Oracle sql Developer
I have the following usernames/schema: shopping shops[shopping] In both users I created a table named “SHOP_TAKE_CART”, I use shopping for testing purposes and shops[shopping] to publish …