Interested to Buy Any Domain ? << Click Here >> for more details...
Where the integrity constrints are stored in Data
Dictionary?
- 1 Answers
- 6622 Views
- I also Faced
- E-Mail Answers
Answer / tulsi
check the data dictionary tables
user_constraints
user_cons_columns
| Is This Answer Correct ? | 6 Yes | 0 No |
what is data integrity? : Sql dba
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
What does plv msg allows you to do?
What is difference between db2 and sql?
Can two tables have same primary key?
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
How many triggers can be implemented for a table?
Is hadoop a nosql?
How many unique keys can a table have?
define join and explain different type of joins? : Sql dba
Is inner join faster than left join?
What is trigger explain with example?
-
Oracle (3253) - 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)
