What is an exception in PL/SQL? What are the two types of exceptions?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between where clause and having clause? : Sql dba
How will you a activate/deactivate integrity constraints?
table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004
Mention what are the benefits of pl/sql packages?
What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?
What are local and global variables and their differences?
write a query to delete similar records in particular fields(columns) in different tables
What is pl sql commands?
What is update query?
What is the source code of a program?
Which is better stored procedure or query?
What is the function that is used to transfer a pl/sql table log to a database table?
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)