![]() |
| 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 Latest Answer : A sequence generates a list of unique numbers that identifiy the rows and columns of a table. ... Read Answers (9) | Asked by : Geetha 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? I am having WHEN-NEW-ITEM-INSTANCE trigger at Form, Block, Item level what is the sequence of execution? And if I want to change there sequence how I have to change? 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 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 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||