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 |
What is rtm in testing?
What is Difference between StoredProcedure and function?
table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.
How do I run sql profiler?
Where is pl sql used?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
explain the delete statements in sql
The select into statement is most often used to create backup copies of tables or for archiving records?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
Is sql low level language?
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)