Explain locks? : Transact sql
No Answer is Posted For this Question
Be the First to Post Answer
How do u count no of rows in a table?
Explain the methods used to protect source code of pl/sql.
What are the return values of functions SQLCODE and SQLERRM ?
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?
What is pl sql block structure?
What are aggregate functions in sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is a subquery in sql?
How can we find duplicate records in a table?
What is rownum and rowid?
How can use stored procedures in 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)