What is the primary key?
No Answer is Posted For this Question
Be the First to Post Answer
Does postgresql run on the cloud?
How do I find sql profiler?
What are triggers and its uses?
what is 'mysqlimport'? : Sql dba
what are the performance and scalability characteristics of mysql? : Sql dba
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.
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
how will u find statistics of a database objects?
What is materialised View?
When is the explicit cursor used ?
How do you get all records from 2 tables. Which join do you use?
What do you know by pl/sql 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)