what is the difference between truncate and delete statement? : Transact sql
No Answer is Posted For this Question
Be the First to Post Answer
hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance
How do I count rows in sql?
How to get the 3rd column(i.e all the data along with the column name)in a table?
How many postgresql users are there, worldwide?
Do we need to create index on primary key?
List and explain the different types of join clauses supported in ansi-standard sql?
Types of indexes. What is the default key created when a primary key is created in a table ?
How to find 3rd highest salary of an employee from the employee table in sql?
What are triggers in sql?
Is pl sql a scripting language?
What is sql dialect?
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.
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)