Differences between Oracle 9i and 10g (Probably in terms of
SQL and PL/SQL)?
No Answer is Posted For this Question
Be the First to Post Answer
What is pl sql variable?
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 add a primary key to a table?
Can two tables have same primary key?
What schema means?
what are the nonstandard string types? : Sql dba
in table there r so many rows write a query which two rows r updated last two day befor?
What does closing a cursor do?
What is difference between stored procedures and application procedures?
Explain lock escalation? : Transact sql
How to look at the current sql*plus system settings?
While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
Oracle (3253)
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)