Why primary key is required?
No Answer is Posted For this Question
Be the First to Post Answer
Give which cursor is better for better performance means type of cursors?
What is mutating table error?
what is the difference between trigger and constraint?
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 procedure explain with example?
What is difference between TRUNCATE & DELETE?
16 Answers Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,
How do you remove duplicates without using distinct in sql?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
How do you declare a constant?
Will truncate release space?
what is primary key? : Sql dba
how do you know the version of your mysql server? : Sql dba
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)