Explian rowid, rownum? What are the psoducolumns we have?
No Answer is Posted For this Question
Be the First to Post Answer
Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?
What is inner join in sql?
Is microsoft sql free?
What is the example of procedure?
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.
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Can you have more than one trigger on a table?
What are the types of triggers ?
26 Answers Aspire, BirlaSoft, TCS,
what is row? : Sql dba
What is partition by in sql?
What is time based sql injection?
Does mysql support 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)