SQL

Home Answers Viewqa SQL SQL

QuestionAsk Questions?

asmit

SQL
1 Answer(s) 4 months and 13 days ago
Posted in : SQL

1)What is ref cursor? Where u can use this ref cursor?

2)What is difference between procedure and function?

3)What is trigger? How many types of triggers are there?

4)What is cursor? Explain different types of Cursors with example?

View Answers

February 7, 2013 at 6:14 PM

ref cursor is a variable of pointer data type which contains the reference of another cursor. ref cursor is generally used where the dynamic select statement is executed and required to retrieve more than one records.
For difference between procedure and function please go through the following link http://www.roseindia.net/answers/viewqa/SQL/13605-What-is-difference-between-a-PROCEDURE-&-FUNCTION-.html
Trigger in database is a procedural code which is written for executing automatically on the response of certain events occurred on the particular table or view in database.

There are two types of trigger :

Row level trigger : These type of tiggers are executed for each row on update, insert, or delete.

Statement level trigger : These type of triggers are executed for each sql statement executed.
Cursor in database is a control structure which allows for traversing acrros records of database. Using cursor complex logic can be performed on row by row basis.

There are two types of cursor :

implicit cursor : These cursors are created implicitly i.e. when the DML statements such as insert, update, delete is executed.

explicit cursor : These cursors are created when the select statement is executed and it returns more than one row however, the action can be performed on one row at a time.

sql
difference between sql and oracle what is the difference between sql and oracle

sql
sql how to get first row in sql with using where condition in sql? how to get last row in sql with using where condition in sql

sql
sql I want interview sql questions Please visit the following link: SQL Tutorials

Sql
Sql how to find maximum of a101,a102,a103 from a table in sql

SQL
SQL hii What is sql? hello, SQL, which stands for Structured Query Language, is a special-purpose language used to define, access, and manipulate data. SQL is non procedural, meaning that it describes

sql
sql returning value from a store procedure in sql with example Please visit the following links: http://www.roseindia.net/mysql/mysql5/stored-procedures-and-functions.shtml http://www.roseindia.net/sql/create

SQL
SQL In my computer i have microsoft sql 2008.how can i set that in the cmd.i want to use that in cmd.what is the default username and password

SQL
SQL 1)How to Store 1000 records in Oracle object. 2)Write a query for calculate highest, 3rd Highest & 10th highest salary from emp teble. 3)What is Sequence. 4)How to use rowid in Sql. 5)What is Views. 6)How

SQL
SQL how to get ( 15 march 2011) and (15/03/2011) output using SQL Use the following queries to get the data from database in the given format. For (15 march 2011) format: SELECT DATE_FORMAT(dob, '%d %M %Y') FROM

SQL
SQL Trigger query Why we use the Trigger and what it's uses? A database trigger is procedural code that is automatically executed..., user events, and SQL statements to subscribing applications 10)Restrict DML

SQL
tables EMP, and DEPT, the structure for which are given above. Write SQL queries

SQL
events, user events, and SQL statements to subscribing applications 10)Restrict DML

SQL
, user events, and SQL statements to subscribing applications 10)Restrict DML

SQL
events, and SQL statements to subscribing applications 10)Restrict DML

SQL

sql

SQL

sql

SQL

sql - SQL
order by SQL Query What is order by in SQL and when this query is used in SQL?Thanks! Hi,In case of mysql you can user following query.Select salary from salary_table order by salary desc limit 3,1Thanks

sql - SQL
want query? 4.what is the diffrence between sql and plsql? Hi Friend... HAVING n>1; Difference between SQL and PL/SQL: SQL is a structured query...(select,insert,update etc.), manipulate objects(DDL) and data(DML). PL/SQL

sql - SQL
sql write a dyamic sql program to display the name of a employee whose salary is <5000 Hi Friend, Use the following query... the following link: http://www.roseindia.net/sql/ Thanks

SQL - SQL
SQL Jus c da case we hve certain images in some folder or some area in sql can we create trigger or procedure so dat in front like in asp page while clicking image it will be showed in page ...... ...I mean writing code for each

SQL - SQL
SQL How to combine 'LIKE' and 'IN' operators in sql query? select name from tab1 where name like 'R%' AND city in('bangalore','mumbai'); Table Name: tab1 FieldName ===================== | name | city

sql - SQL
sql functions with examples I need sql functions with examples to learn fast. Hi friend,<%@ page language="java" import...("SQL statement is not executed!"); } } catch (Exception e

sql - SQL

SQL - SQL

sql - SQL

SQL - SQL

sql server - SQL
sql server what is SQL server? & what is oracle? are they same

sql server - SQL
sql server How many no of tables can be joined in same sql server

SQL help - SQL
SQL help Hi Deepak, Can u pls tell me what is the difference between PL/SQL and MYSQL? Is there any difference in generating the code

SQL JOINS - SQL
SQL JOINS Hom many Joins In Sql?plz explian all those things? Hi Friend, Please visit the following link: http://www.roseindia.net/sql/sqljoin/index.shtml Hope that it will be helpful for you. Thanks

learn sql - SQL
learn sql how to learn sql......idont know anything about programming knowledge Hi Friend, Please visit the following link: http://www.roseindia.net/sql/ Thanks

sql 2000 - SQL
sql 2000 why binary data when inserted into the sql column of data type image or binary is stored in the form of hexadecimal nos. instead of the name of the file inserted????? Thanx for ur response in advance

An SQL Locator.
An SQL Locator. What is an SQL Locator

sql component
sql component is sql package is the component of jdbc

auto sql script - SQL
auto sql script Is there a way of generating inserts scripts using the table structure for oracle database

SQL injunctions - SQL
SQL injunctions Could you please tell me how to handle the sql injunctions? Hi friend, SQL injection is a technique that exploits.... Prevention against SQL injection, User input must not directly be embedded in SQL

Latest
Frameworks
Category