Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288) How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?
1 7153what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
5 19524I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
MTS,
7 10449can u pls share responsibilities for production how to environment in odi?and how to generate report ?
2393I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.
4 12415Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
CTS,
2 10621difference between table level constraint and column level and advantages of table level constraint
4 15624Why foreign key column allowing null values even a parent tables reference key column not having null value..
IBM,
2 6219What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?
1 8812
Is there a combination of "like" and "in" in sql?
Is microsoft access still used?
What is index length in mysql?
What is database architecture?
What is different keys in dbms?
How sql server enhances scalability of the database system?
State some of the products of sybase?
How do you set a trace flag in sql server?
Can you roll back the ddl statement in a trigger?
Determine when an index is appropriate?
What does a senior database administrator do?
What the difference between UNION and UNIONALL?
What are out-of-range errors with date and time literals?
Data structure used to implements a menu:
What is plpgsql language?