Problem : Divide a given string into individual characters and display these characters into separate rows through a SQL query. For example , the given string is 'Paper', display it as :
Given_String
--------
P
a
p
e
r
The query is :
select substr(&string,rownum,1) given_string
from all_objects
where rownum<=length(&string)
sqlite3
-
I just tried sqlite. It is ultra-light and support SQL commands. Just try
this $ sqlite3 test.db SQLite version 3.26.0 2018-12-01 12:34:55 Enter
".help" fo...
5 days ago
No comments:
Post a Comment