What is scalar function?
No Answer is Posted For this Question
Be the First to Post Answer
Write the command to remove all players named sachin from the players table.
What is field delimiter?
Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)
What is the main reason behind using an index?
When can we use the where clause and the having clause?
What is exit statement?
what is cursor. write example of it. What are the attributes of cursor.
select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?
Types of cursor locks and explanation each of them ?
What is a pl/sql block?
how instead of triger is helpful for mutating tables errors handlling ?
Can we use ddl statements in stored procedure?
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)