Skip to content

Tag: oracle11g

Split String using SQL’s REGEXP_SUBSTR

I need to split a string like this (NUL) means a character with ASCII value 0. Don’t know how to type it here. I need to split this when (NUL)~ occurs. So the expected result after split is RANDOM(NUL)THIS_SHOULD_BE_SPLIT THIS_IS_NEW(NUL)STRING THIS_IS_ANOTHER_STRING(NUL) Using OracleDB not sure how it …

Oracle SQL UNION alternative

I’m using ORACLE SQL (11g), lets assume we have a table named TRANSMISSIONS which has field that holds file sizes I want to perform various aggregate functions on various partitions let’s say for different file sizes. However I want the partitions to be cumulative. So a 10 KB file will be both in …

Trying to run script through Oracle 11g

I am trying to run SQL statements in the Oracle 11g Express edition, where I am to create tables. Here is my SQL code: It only ends up processing 4 statements and I keep getting these error messages: I am wholly unfamiliar with Oracle 11g. I am unsure if I am using the correct application in it for my assignm…