What is the difference between SQL Constraint and PL/SQL
constraint.Pls give all the constraint name.
Answers were Sorted based on User's Feedback
Answer / siva
Both SQL Constraint and PL/SQL constraint are the same.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kotesh
sql & plsql constraints are same
namly
primary key
check
not null
unik
foreign key
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dinesh
SQL:- Primary Key,Foreign Key,NOT NULL,CHECK,DEFAULT Etc
PL/SQL :-Trigger just use a constraint
| Is This Answer Correct ? | 0 Yes | 0 No |
i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.
How to call DDL statements from pl/sql?
What is the difference between jpql and sql?
What are sql commands?
what is a cursor
What is parameter substitution in sql?
explain normalization concept? : Sql dba
Are subqueries faster than joins?
how to enter numeric values as hex numbers? : Sql dba
how to convert numeric values to character strings? : Sql dba
how to create object in plsql
Why partition by is used in sql?
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)