Can we use view in stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
What view means?
I want to know last five transactions or records from emp table, from now?
what is commit? : Sql dba
What are sql queries used for?
How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?
How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }
What are keys in sql?
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...
----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6
Explain cursor types?
How do I start pl sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
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)