I have a query joining two tables. RESULT_TABLE: ID, TEST_RESULT , TEST_STATUS EMAIL_TABLE: ID, EMAIL_TYPE, EMAIL_ADDRESS The RESULT_TABLE will typically have only one result per student. A …
Tag: oracle
Getting IMP-00403 warning when using IMP (12.2.0.1.0) but the generated import_sys.sql which failed is empty
I have an Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 on Windows 2019 (64bit). In short, when importing a dump file I’m getting the following: IMP-00403: Warning: This import generated …
Oracle – How to partition by case statement
I have the following Oracle SQL in a report that I inherited. The bucket1_days_prc and overdue_prc should show the percentage of the number of invoices that falls within those buckets based on the …
Can I combine these two queries into a single query?
Note:AUT_GROUP_ID column in Table CBS_OWNER.AUT_GROUP_MAP is the only factor differentiating both queries. AUT_GROUP_ID IN (20,4,7) —>ONNET AUT_GROUP_ID IN (3,6) —> OFFNET The first query …
Count of Value column with case when and group by
Table: Date Id Value 2019-02-09 a1 ab 2019-01-12 a2 cd 2019-12-12 a1 ab 2017-07-23 a1 ab 2018-12-09 …
Formatting names in a single column in sql oracle
I need to help. I am new in tha oracle. I have a simple problem. My table: create table employee (name varchar2(30)); insert into employee values (‘kevin durant’); insert into employee values (‘…
On delete Error: SQL Error: ORA-00933: SQL command not properly ended
I’m trying to delete a student record from the database using the below query. But I face this error. Error report – SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 – “SQL command not properly ended” Answer Give this a shot to delete student record for which the…
Error missing identifier oracle in FROM at line 13
It says there is an error at line 13. It says: I don’t understand what it means. Please, help. Edit: I also tried this: It says it doesn’t recognize ‘departamento.nombre’ Answer seems you missed a table .. try add a join for departamento
getting number of columns and rows in my tables
How to get the number of columns and rows for each of my tables in oracle? So far I know how to display the number of columns for each table: Answer
SUBSTR in oracle not working when there is line break in the string
Okay so I am working with a database that has data in many formats. I was asked to split a string into 3 columns by 150 length in each column The data in the table is stored as this I want to split this data into 3 columns , COL1, COL2, COL3 When I use this query it works fine.