 Related Questions Latest Answer : You can get the current value of the Sequence by querying DBA_SEQUENCESColumn name is Last_numberThanksHari Kiran P. ... Read Answers (3) | Asked by : ram How to store a bitmap or jpeg file on oracle database?which datatype is used and what is the retrival method ? Hi,Need to generate an 6 digit sequence number automatically for employee numberin front end (Oracle Hi,Need to generate an 6 digit sequence number automatically for employee numberin front end (Oracle Applications)Module HRMSeg - 000001,000002.Pls update on thisRegardsVenu Read Answers (1) | Asked by : venu I want to use a column as blob datatype incase of long raw datatype.what is the process of data insert into and retrive from this table . View Question | Asked by : jagannath kar Is there any limit on like this number of parameters should be passed into a function? Or can we pass any number of arguments into a function? View Question | Asked by : Jyothi What is the difference between bind and declare variable in pl/sql?What is the difference between number,integer, pls_integer and binary integer? Read Answers (2) | Asked by : Abhishek Latest Answer : SELECT COUNT(cname)FROM COL c, TAB TWHERE T.Tname = c.Tname AND T.Tabtype='TABLE' AND T.Tname ='EMP'; ... Read Answers (2) | Asked by : anil How to write RESERVE WORD as table column?For example if you want to write Number as table column name How do you write? Read Answers (4) | Asked by : manisha Latest Answer : First of all this is a convention.Second thing is that if they start writing as varchar1 people will be confused this with char so they named it like this. ... Read Answers (1) | Asked by : Maheshwar Singha Latest Answer : 1. float 2. decimal 3. double precision 4. int 5. integer 6. numeric 7. real 8. smallint ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
