Interested to Buy Any Domain ? << Click Here >> for more details...
1. is it possible to use the cursor atttibutes (%found ,%
rowcount , %isopen , %notfound ) to our user defined cursor
names .......
cursor cursor_name is select * from scott.emp
if you use...
cursor_name%found , %rowcount ,%isopen,%notfound...will it
work...
--------------------------
2.what is the difference between the varray and index by
table ..
--------
3.
type type_name is table of number(8,3)
index by binary_integer;
identifier_name type_name;
first , last , prior , next ,trim are the methods we can
use it for the above type...simillary is there any way to
apply for cursors...
with thanks and regards..sarao...
- 0 Answers
- 2429 Views
- Satyam, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
What are sql commands?
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
What is a sql driver?
What is meant by truncate in sql?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
What is the difference between execution of triggers and stored procedures?
explain the difference between bool, tinyint and bit. : Sql dba
What is the difference between view and stored procedure?
How One can easily select all even, odd, or Nth rows from a table using SQL queries?
Can we rollback delete command?
What is ROWID?
-
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)
