The Heap™ – Consultancy ©®

« first day (3429 days earlier) ← previous day next day → last day (1445 days later) »

Andriy M

7:17 AM

Morning

John aka hot2use

Morning

2 hours later…

deostroll

8:50 AM

How do i use the psql binary to execute a drop database if and only if the database exists, all through the command line using the -c switch? #postgres

ypercubeᵀᴹ

9:24 AM

@deostroll -c 'DROP DATABASE IF EXISTS dbname ;'. ??

deostroll

9:59 AM

Yes. Thanks. I used to use an if exists statement before...but as of 9.0+ I guess if statements are supported in functions...

3 hours later…

nutty about natty

1:26 PM

Hi there

any ideas how to resolve this:

Replacing "269" with "160" returns the must be followed by four hexadecimal characters error](oracleerror.com/2016/07/30/…) (in 11g). Any idea why and how to resolve? My XML strings contain many of these  , amongst others. Thanks! — nutty about natty 3 mins ago

(cf. stackoverflow.com/a/9171071/2153622)

ypercubeᵀᴹ

1:40 PM

@nuttyaboutnatty this is a comment and on a different site, SO.

Ask a question on our site and someone will answer, I am sure.

nutty about natty

1:58 PM

xss not okay? ;-)

6 hours later…

ypercubeᵀᴹ

8:19 PM

good one

nutty about natty

Q: How to convert xml entities to unicode characters (with read-only access) in Oracle?

I'm connected to an Oracle Database (11g Release 2 - 11.2.0.4), with read-only access. Into this database, some of the data is uploaded via, or rather as, XML - and quite a few entries contain multiple occurences of XML (special) character entities in the format of &#nnnn;. So far I have dealt ...