What is Collation Sensitivity ? What are the various type ?
No Answer is Posted For this Question
Be the First to Post Answer
what are the advantages of primary key over unique+notnull
7 Answers Consultancy, LGS, Oracle,
define sql delete statement ? : Sql dba
how to get second highest salary in SQL(as/4000
Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.
What is materialized view. What are different methods of refresh?
Difference between views and materialized views?
What is column?
What are database links used for?
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.
What is nested table in pl sql?
Define overloaded procedure?
How many types of cursors supported in 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)