|
|
Browse by Tags
- 10.2.0
- 10.2.0.3
- 10f
- 10GR2
- 15.0
- 1-to-8
- 7.x
- 8.x
- 9
- 9.2.0.5
- 9.2.0.8
- 9.x
- ase
- between
- codd
- comparison
- create table
- database
- Database design
- Database Logic
- db
- db design
- db diagram
- dbms
- ddl script
- defination
- diagram
- difference
- er diagram
- hdbms
- host string
- imp utility
- Import utility
- join tables
- list
- Migrating from PA-RISC to ITANIUM
- normalization
- normalizations
- one-to-many
- oracle
- Oracle 11G
- Oracle Dabase
- Oracle Enterprise Edition
- performance
- query
- Relational Database
- relationships
- rules
- server
- sql
- SQL PLUS
- SQL query
- sql script
- sql syntax
- SQL*Plus
- sqsh
- Sun and Linux
- sybase
- union
- unix
- vs
-
Difference between DBMS and RDBMS
I want to know the exact difference between DBMS and RDBMS. what is the advantage of having relationships in a Database Management System -
RDBMS Defination
What is the pet defination of RDBMS, and what is the difference between DBMS and RDBMS. Quote with examples please. Is Visual Basic an DBMS tool? -
RDBMS comparison
At present we are working with sybase in HP - 9000 platform. As we have planned to upgrade the system, please provide a comparison on sybase vs oracle vs mssql vs mysql or please mention related sites. -
HDBMS vs RDBMS vs ODBMS
Hello, Could some one explain the comparisons between HDBMS vs RDBMS vs ODBMS with a example. Any links or white papers would be helpfull. We have to present a article on the same. Thanks. -
One to One Relationship and ON DELETE CASCADE - RDBMS Design
Customer and CustomerPrivateInfo are meant to be one to one relationship. If CustomerPrivateInfo record is attempted to be deleted, prevent deletion. If Customer record is deleted, delete its associated CustomerPrivateInfo. Does the DDL below fulfill my request? I'm using Oracle... Code Snippet:... -
How to Draw Diagram for My Database Design?
I find database designs get the db designer mixed up/confused in some point of designing. Is there a certain diagram flow that is commonly known amongst designers? When i design a database, it comes to a point i feel i want to put them all in one sheet of paper so i can know what goes in and what goes... -
Simple Question About RDBMS Design - SQL - I Need Suggestion
http://img3.imageshack.us/img3/6989/53645000.jpg Beside CustomerFamilyMembers entity you will see (0,6). This means a customer does not need to have a family in case a customer is single. However, in case a customer has a family, the family members can not exceed 6 members. If i did (1, 6), this means... -
SQL*Plus Error While Running a DDL Script - Oracle
I have DDL Script. When i run every table DDL script individually, tables gets created. However, when i run the whole script by doing: SQL> @C:\Users\Home_User\Desktop\motel_db_schema.sql I got error for one the tables which screws up all the child tables too. This is the error i get: SP2-0734: unknown... -
Why Can't I Use Currval in Select Statement? - Oracle
I was trying to do SELECT employeename, job_id_seq.CURRVAL FROM employees; I got an error. Can't i call CURRVAL of a sequence via SELECT like above? Why? I know it would work if i do it on DUMMY table. Can i use name.CURRVAL via INSERT INTO? Why? -
Can I Put CREATE SEQUENCE - NEXTVAL Within CREATE TABLE - Oracle?
I created some sequences. I would like to indulge into the primary key column in CREATE TABLE script. How can i do it?