What is cursor and why it is required?
No Answer is Posted For this Question
Be the First to Post Answer
Do we need to rebuild index after truncate?
If we have n no of columns in a table, can we add new column in that table with not null constraint?
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
Can we use ddl statements in stored procedure sql server?
How to run sql statements with oracle sql developer?
What are different sql data types?
what is self join and what is the requirement of self join? : Sql dba
Which are the different character-manipulation functions in sql?
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
How can analyze query after generating explain plan ?
what is a relationship and what are they? : Sql dba
What is set transaction?
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)