How to generate a report with all the columns within a single field inside a single repeating frame in the Layout.
Latest Answer: that is background processes because SGA is the memory area allocated during instance startup. ...
Evaluate this query?Select e.emp_id from emp@wing e; What is "@wing" ? Is it a partition on emp table or a constraint on table emp?
How to write RESERVE WORD as table column?For example if you want to write Number as table column name How do you write?
How do you decide on whether to use a Procedure or a Function for a particular task ?Is it possible to get the last 10 rows of a table? If Yes How?
Latest Answer: SELECT COUNT(cname)FROM COL c, TAB TWHERE T.Tname = c.Tname AND T.Tabtype='TABLE' AND T.Tname ='EMP'; ...
What is the difference between bind and declare variable in pl/sql?What is the difference between number,integer, pls_integer and binary integer?
Latest Answer: yes the table can have primary key as well as unique constraint in a table.a table can only have a single primary key were as it can have more than one unique key ...
I will be getting this duration from the dual table. Provide query for this.Like for example, if suppose I am going to get value from the month of 01-Jan-2006 to 31-Apr-2007 then My result should be only
Latest Answer: SELECT TO_CHAR(ADD_MONTHS('01-jan-2007', ROWNUM-1), 'MON')FROM dualWHERE ADD_MONTHS('01-jan-2007',ROWNUM-1) < '30-apr-2007' CONNECT BY LEVEL
View page << Previous 7 8 9 10 [11] 12 13 14 15 16 Next >>
Go Top
