oracle postgresql

I have a bunch of products with a bunch of different possible attributes for each product. E.g. Product A has a name, size, color, shape. Product B…

I am considering designing a relational DB schema for a DB that never actually deletes anything (sets a deleted flag or something). 1) What metadata…

Is it possible to do SQL's CLR assembly in other DBMS? or what would be the CLR analog in DBMS Oracle, MySQL, PostgreSQL ...

Hallo, I am writing a database application that does alot of inserts and updates with fake serialisable isolation level ( snapshot isolation ). To…

I am using Talend studio, testing it for a simple migration from an Oracle database to a postGres database. The two connections are ok, but I got…

I have a little silly question. I have installed a PostgreSQL DB Server, but when I run query, there is a problem with column identifier without…

I'm trying to build a filtering system for products. Products have many attributes including price, size(cm) and (# of) sides. I want to construct…

I have to tables in my database : table1 column1|column2|column5|column13 harry marry stan kyle table2 column1|column2|column12|column7 kenny eric…

I am trying to make a method for a class that will automatically insert a record into a table. The problem is that I need to make the code work for…

I am currently testing a few different relational database management systems. (MySQL, PostgreSQL, Oracle and Firebird SQL) using a Java application…

Hi All, Actually I have some oracle query which is about oracle database default tables. That is working in the oracle. Now I want to execute those…

How much we can extend the Oracle's Horizontal and Vertical Scalability (approximately). And how about HDFS (Hadoop Distributed File System)?? How…

For example, given 3 tables: gastropod snail slug and assuming we want to enforce that every row in 'gastropod' has exactly one corresponding row in…

In Postgresql, if I do ALTER TABLE mytable DISBLE TRIGGERS ALL , all triggers and constraints regarding this table are suspended. Especially,…

Extending on How does hibernate use an empty string for an equality restriction? I am having a problem about how to check for an empty string…

I have one table it contains the record .The below is the sample. $40608$<12988> What we need ? I need to update the record where it presents…

Hi, I tried several ways through internet and scripts to use MySQL dump "xxx.sql" and ORACLE dump "xxx.dump" to postgresql database. Nothing worked…

I've been doing SQL for several years, and throughout all that time, my thought of joins was that of equivalence joins, as in select ... from t1…

I have a sql query that can easily return 70,000 rows of a relational database table (with a few joins involved). The total size of this resultset…

i search tricks to know and change the port of oracle, mysql and postgresql database, i mean a dos command or human machine interface.