Explain autonomous transaction.
No Answer is Posted For this Question
Be the First to Post Answer
ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.
Explain some predefined exceptions.
Can we use ddl commands in pl sql?
Do ddl statements need commit?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
What is Difference Between delete and Truncate?
What is the function that is used to transfer a pl/sql table log to a database table?
what happens if null values are involved in expressions? : Sql dba
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
what is offset-fetch filter in tsql? : Transact sql
how to findout the 100th maximum salary
What is difference between a PROCEDURE & FUNCTION ?
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)