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 |
Who developed sql?
what is column? : Sql dba
What is a REF CURSOR? Compare strong and week ref cursor types.
How can i insert data inro a table with 3 columns using FORALL?
Show code of a cursor for loop.
table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0
What is hibernate and its relation to sql?
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
how to use myisamchk to check or repair myisam tables? : Sql dba
What is the syntax and use of the coalesce function?
What is the difference between a subquery and a join?
What are the different types of dbmss?
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)