How do you delete duplicates in sql query using rowid?
No Answer is Posted For this Question
Be the First to Post Answer
How do you determine the current isolation level? : Transact sql
Explain architecture of sql server notification services?
What is sql table?
State the advatage and disadvantage of Cursor's?
Is nosql faster than sql?
Is pl sql different from sql?
How can you fetch common records from two tables?
What does truncate mean in sql?
what is sub-query? : Transact sql
Can we rollback truncate?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
Explain the two type of Cursors ?
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)