 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 : IN->Equal to Any One in the List.ANY->Compares Value to Each Value Returned by the Sub Query.ALL->Compares Value To Every Value Returned by the Sub Query.For Example:IN:(Q):Display the Details of all the Employees Whose Salaries are ... Latest Answer : Dual is a system defined table having one rows and one column. A person who has informed that it has virtual
existence is not proper. It has physical existence.Ex:SQL> select * from dual;D-XMeans a table having single row and columns.Regards,Deepak ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
