ORA-00001: Unique constraint violated
Random ramblings and raves of relational relevance!
Showing posts with label
sql
.
Show all posts
Showing posts with label
sql
.
Show all posts
Tuesday, March 21, 2017
Using VS Code for PL/SQL development
›
I've been using Sublime Text as my main editor for PL/SQL development for many years, but I'm now in the process of switching to Vis...
20 comments:
Tuesday, July 7, 2015
Longer names coming to Oracle?
›
Have you ever, like me, been silently finger-counting the number of characters in a table name, column name or procedure name that you are a...
3 comments:
Friday, May 25, 2012
A friend in need: Flashback Query
›
"It is sayd, that at the nede the frende is knowen." - William Caxton: " Sonnes of Aymon " (1489) "I say, tha...
1 comment:
Saturday, April 10, 2010
SELECT * FROM spreadsheet (or How to parse a CSV file using PL/SQL)
›
I recently needed to retrieve/download a comma-separated values (CSV) file from a website, and insert the data in an Oracle database ta...
34 comments:
Tuesday, April 6, 2010
Using TRUNC and ROUND on dates
›
Maybe this is old news to some, but I recently became aware that it is possible to use TRUNC and ROUND not just on a NUMBER, but also on a D...
3 comments:
›
Home
View web version
