Top "Oracle" questions

Hello I am trying to display the constraints in one of my tables but for some reason I get the …

This is a situation I'm generally facing while writing SQL queries. I think that writing the whole column (e.g. …

While deploying my .NET 3.5 Windows form to different environments we ran with lots of invalid provider issues. It works on …

I am sorry, for bugging you all with a very silly question probably, but I just started learning data base …

I've been messing around with Django and the Django ORM at home, and I've got to say, I feel it …

I've got a parent table, which has a dozen child tables referencing it. Those child tables in turn have other …

I'm trying to convert a number (yyyymmdd) to date (mm/dd/yyyy) For example 20150302 ====> 03/02/2015

I'm triyng to unpivot multiple columns in my dataset. Here's what my data look like. CREATE TABLE T5 (idnum NUMBER,…

I have a column details designed as varchar in oracle DB, this DB is being used now for customers and …

I have a table having one clob column which has XML data in it. Say I want to replace XYZ …