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 |
Why stored procedure is better than query?
Store procedure will return a value?
What is the difference between rename and alias?
wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?
4 Answers Oracle, TCS, Tecnics,
How to add a column ‘salary’ to a table employee_details?
Talk about views
Show how functions and procedures are called in a pl/sql block.
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What do you understand by pl/sql records?
What are different clauses used in sql?
How do you exit 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)