What are the different types of PL/SQL program units that
can be defined and stored in ORACLE database ?
Answers were Sorted based on User's Feedback
Answer / pratima
CONSUMER GROUP
DIRECTORY
FUNCTION
INDEX
INDEXTYPE
JAVA CLASS
JAVA RESOURCE
LIBRARY
OPERATOR
PACKAGE
PACKAGE BODY
PROCEDURE
SEQUENCE
SYNONYM
TABLE
TRIGGER
TYPE
VIEW
| Is This Answer Correct ? | 1 Yes | 0 No |
What is normalization sql?
What is where clause in sql?
when a procedure /package is getting invalidated?
How do I run a pl sql procedure in sql developer?
What is the primary key?
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
If a cursor is open, how can we find in a pl/sql block?
How do I view output in sql developer?
What is cursor in pl sql?
What is the use of stored procedures?
What is the usage of NVL?
7 Answers Infosys, Micro Infotek,
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
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)