database oracle

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

When I let this Query run in my Oracle SQL Developer 1.5.3 select COLUMNNAME , REPLACE( COLUMNNAME, 'BEFORESTRING', 'AFTERSTRING' ) as COLUMNNAME…

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…

Hi All, I have more than 100GB size of table in my database I want to rename the table name. Is it a good idea?

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

I apologize for this question but I just can't seem to find much about the two. I currently use Mysql and it's becoming old school now. Mysqli is…

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

I'm working with an incompletely documented DBMS system, and I am looking for a general purpose software tool that will examine the values in…

Say that I have vendors selling various products. So, at a basic level, I will have the following tables: vendor , product , vendor_product . If…

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'm a Java retread pretty new to C#. I'm hoping to stay out of trouble when I crank out a bunch of DML code in the next few weeks. I'm used to the…

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

I guess that's it. It's all in the title. I think that MySQL is theoretically aimed at people like me who mostly have small - to medium -sized…

I want to import data from a MySQL server into Oracle database, and I found a suggestion to use Oracle database link. The Oracle instance is…

I need guidance on creating Classes that will interact with Oracle/mysql. The basic requirements would be to : connect/disconnect to/from…

Hi All what is the best way to write SQL statement that is compatible with mysql,oracle,and mssql database. for example when i try to execute this:…

I want to encrypt my tables such that union, intersection and join operations are still feasible. Suppose I have two tables both encrypted and I…

Is there a way in SQL to use a query that is equivalent to the following: select * from table1, table2 where some_join_condition and…

Hello Friends, I have no good knowledge about databases, so please can you tell which database is easy to learn & use and provide best…

We are using a mysql database w/ about 150,000 records (names) total. Our searches on the 'names' field is done through an autocomplete function in…