Write the order of precedence for validation of a column in
a table ?
Answers were Sorted based on User's Feedback
Answer / nishi
done using Database triggers.
done using Integarity Constraints.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / tulsi
done using Database triggers.
done using Integarity Constraints.
| Is This Answer Correct ? | 0 Yes | 4 No |
Explain aggregate functions are available there in sql?
What is pivot in sql?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
What are the different operators available in sql?
Is a secondary key the same as a foreign key?
What company owns postgresql?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
what is the difference between where clause and having clause? : Sql dba
How can we debug in PL/SQL?
What is the difference between local and global temporary table?
What is pragma exception and how, when, where us
I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
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)