What are the datatypes a available in PL/SQL ?
Answers were Sorted based on User's Feedback
Answer / highness
mainly two types
1. scalar 2. composite
1.
boolean
char
binary integer
number
variable
constant
raw
rowid
2.
records
tables
varrays
| Is This Answer Correct ? | 2 Yes | 0 No |
what is index? : Sql dba
Is postgresql a server?
Is record in pl sql?
is it necessary to write group by and order by clause together
if i perform any operation on views such as insert, delete etc will my base table get affected?????
is it possible to pass an object or table to a procedure as an argument?
what is the cursor and use of cursor in pl/sql ?
in table there r so many rows write a query which two rows r updated last two day befor?
List the different type of joins?
what is the output of this query selet * from employee where 1=2 ??
What is procedure in pl sql?
in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out
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)