python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - substr

Selecting fields from multiple tables with Where and Substr

Not sure what I'm doing wrong here. I've been trying all week and can't find the problem. I'm new to oracle so I'm hoping it's something easy I'm missing. My script is below. I'm trying to pull stu...
test-img

user17986852

sql

oracle

select

where-clause

substr

Votes: 0

Answers: 1

Latest Answer

There is a stray || after t.email_addr, and the line with '' before the FROM clause shouldn't be there. select s.student_number||','|| s.first_name||','|| s.last_name||','|| s.schoolID...
test-img

William Robertson

Getting the last character in an Oracle CLOB column

I am having an issue with getting the last character from an Oracle CLOB column. The same SQL that works on an VARCHAR column doesn't work on a CLOB column and can't figure out why or how to make it w...
test-img

brent thomas

oracle

substr

clob

Votes: 0

Answers: 2

Latest Answer

Works for my simple test case: SQL> create table test (col clob); Table created. SQL> insert into test (col) values ('This is a cloB'); 1 row created. SQL> select substr(col, length(col),...
test-img

Littlefoot

Datetime GMT format SQLITE query

I've imported some data into a sqlite database and I have two different time format '2020-03-31T16:53:00' ISO FORMAT 8601 'Fri Apr 24 11:08:27 GMT+00:00 2021' I need to generate a report by HOURS and ...
test-img

RedDot

sqlite

date

substr

Votes: 0

Answers: 1

Latest Answer

SQLite's date functions work only with ISO formatted Text dates. Update your table: WITH cte(month, monthname) AS ( VALUES ('01', 'Jan'), ('02', 'Feb'), ('03', 'Mar'), ('04', 'Apr'), ('05'...
test-img

forpas

Posts

Questions

Blogs

Jobs