How to Execute a Package in PL/SQL.?
No Answer is Posted For this Question
Be the First to Post Answer
1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.
Explain the uses of control file.
What are sql indexes?
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What is the maximum number of columns in sql table?
write a query to display diference between two dates in sql server
What are the query optimization techniques?
What is sqlite format?
Why do we create stored procedures & functions in pl/sql and how are they different?
How the execution will be done in exceptions?
Whate is use of MOD function in pl/sql.
What is replication id?
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)