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) Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)
1 5387Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.
5 9608
How do we use distinct statement? What is its use?
Write the SQL query to drop, truncate and delete table.
Can excel and access work together?
what is port in oracle? how is it related to database application.
What command would you use to add a column to a table in sql server?
What is postgres process?
Is mysql a nosql database?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is the difference between dataadapter and datareader?
How a tablespace is related to data files?
how to use in conditions? : Sql dba
What is the difference between migration and upgradation in sql server?
Have you attended the client meetings?
What is a file group?
How to list all field names in the result set using mssql_field_name()?