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 handles NULL characters and if it is possible to split it. To split
Tag: oracle11g
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 the <=500000 bytes partition and the <=2000000000
Joining table get the first data on first table if duplicate
Hi i have table1 and table2. table1 is the logtime table of employees and table2 is the groupcode of the employee. On table1 some employees has duplicate time in because they time in multiple time …
How can I read a very long BLOB column in Oracle?
I want to connect a Node Express API with an Oracle 11g Database which has a table with a BLOB column. I want to read it using a SQL query, but the problem is that the BLOB column can have a very long …
Remove duplicate values from string in oracle
I have requirement where I have input data like Output Required: Solution Tried: Output of the query: Can someone help here in removing repeating alphabets. Thanks Answer You can use a subquery:
Calling a Procedure with name of Table as argument and assigning same datatype to variables as in Table in PL / SQL
following is the code. What I am doing here is passing the table_name as argument (I don’t know how to pass it, I just searched it on stackoverflow and other websites, and came up with this solution. Apparently it is a way to pass the table dynamically however, I don’t know the logic behind) to a procedure and then using
concatenate with leading zeros for months – not a valid month error
I want to concatenate string with year in oracle. The string is month. Query is This query wrks fine however if the string is ’01’ or anything starting with zero i am getting not a valid month error. Answer Let’s run it without the to_date(…, …) wrapper: Do you see the problem? (Note that the result is a number, not
ORA-02290: check constraint violated
I keep getting the message “ORA-02290: check constraint violated” whenever I try to insert values into my table. Here’s the code for the table STORE: And here’s the INSERT statements I am trying to accomplish: It has created the 4th, 6th, and 7th values, but not the rest. What is going wrong? Answer You are violating the CHECK constraint as
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 assignment.
Correlated Subquery working differently for Oracle 12c and 11g
We have a generic table that holds multiple records (DDL and DML below): Below are the records: The query below works in 12c, but Errors out in 11g: It errors out with ORA-00904: “AR_TRX”.”TRX_ID”: invalid identifier. I believe this is caused by the correlated subquery AR_TRX linked to the SELECT statement (see comments “– ERROR HERE” above). I need this