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 |
Can we create a trigger on view?
What is the full form of sql?
What schema means?
What is view explain with example?
i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....
what is the order of pre-defined exceptions.
Why do we use procedures?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
how to include comments in sql statements? : Sql dba
how instead of triger is helpful for mutating tables errors handlling ?
what are the different type of sql's statements ? : Sql dba
How do you modify a column in sql?