|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions 8060 Latest Answer : Hi,Rowsize depends up on the no of columns and their size , you can calculate the avg row size using vsize and maximum we can have 1000 col in table. ... Read Answers (1) | Asked by : Sabby Latest Answer : oracle supports two types of joins: 1.oracle joins cartesian join equi join non equi join self join outer join is exhibited using "+" operator 2.ansii ... Latest Answer : Select * from dba_objects where owner = 'GL' and object_type = 'TABLE'Change GL to AP and AR for respective table info. ... Read Answers (1) | Asked by : mahendra Latest Answer : For time being type below command at sql promptSQL>define_editor=viYou can add export EDITOR=vi in .profile and logou/login for permament changeHope this will solve it ... I am creating one table in oracle. in database it is allocated some memory for that table. how can i know how much memory that table is holding in that database? Latest Answer : ANY and ALL are Multiple row operators.ANY - Greater than the MinimumALL - Greater than the maximum ... Latest Answer : DUAL is a table.That is owned by SYS user .It has a column name as dummy and it containts a row having a vale "X".The dual table is useful when u want to retun a value once only,the value that is not derived in from a table with ... Latest Answer : when a commit occurs in the transaction then the points are as mentioned:-1)an SCN is created & record in redo log buffer2)LGWR writes from Redo log buffer to redo log files3)oracle shows commit complete4)locks now can be released ... How to store a bitmap or jpeg file on oracle database?which datatype is used and what is the retrival method ? Latest Answer : Installation of ORACLE 9i in LinuxRefer this page http://ivan.kartik.sk/oracle/install_ora9_elinux.html#st1 ... Read Answers (1) | Asked by : megh
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
