What is difference between sql function and stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
how to create a database in oracle?
What is the usage of distinct keyword?
what are the authentication modes in sql server? How can it be changed? : Sql dba
Can a trigger call a stored procedure?
What is a constraint?
what is the difference between a local and a global temporary table? : Sql dba
Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.
How do I run pl sql in sql developer?
what is a record in a database ? : Sql dba
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What are the different ddl commands in sql?
How to use sql statements in pl/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)