Search found 16 matches

by srinu_a47
Mon May 05, 2008 6:45 am
Forum: General / Others
Topic: Cost Of Oracle E-business sit
Replies: 1
Views: 1242

Cost Of Oracle E-business sit

hi all
can u please tell me the total price of oracle application e-business suit for all modules ..
I want that cost aurgent ...
Can any 1 provide that details to me...
Thanks in advance
by srinu_a47
Thu Jun 14, 2007 1:49 am
Forum: Oracle Databases
Topic: Why we use collection concept in plsql programms
Replies: 1
Views: 1342

Why we use collection concept in plsql programms

hi friends,
can u plz tell why we use collections in plsql rather than records
and tell me the difference between record and collection.
plz tell me what is the main advantage of collection used in plsql programms

ok thanking in advance
by srinu_a47
Fri Jun 08, 2007 8:46 am
Forum: Oracle Databases
Topic: oracle 10g,11g pdf's of pl/sql
Replies: 0
Views: 1359

oracle 10g,11g pdf's of pl/sql

hi friends
Can u provide me oracle 10g,11g pdf's to me
thanks in advance
bye
by srinu_a47
Mon Jun 04, 2007 7:35 am
Forum: Oracle Databases
Topic: How to create flat file
Replies: 1
Views: 1386

How to create flat file

hi
how to create a flat file and store the same in the system drive using
plsql
thanking u
by srinu_a47
Wed May 09, 2007 3:55 am
Forum: Manufacturing
Topic: Give me datails on mfg
Replies: 2
Views: 2504

Give me datails on mfg

Hi friends,
I am a fresher in Oracle apps. working as trainee Consultant.Can anybody send me pdf's of mfg.
by srinu_a47
Mon Apr 23, 2007 4:08 am
Forum: General / Others
Topic: give me breaf notes on architecture of oracle apps
Replies: 0
Views: 989

give me breaf notes on architecture of oracle apps

plz give me the dreaf notes on architecture of oracle apps
plz send me the pdf's files of oracle applications
by srinu_a47
Tue Apr 10, 2007 4:12 am
Forum: Oracle Databases
Topic: what is EDM
Replies: 0
Views: 1120

what is EDM

plz give me a breaf idea of EDM
by srinu_a47
Wed Apr 04, 2007 8:37 am
Forum: Oracle Databases
Topic: Order by
Replies: 1
Views: 1392

select distinct to_char(hiredate,'month--yyyy') as mon_year , to_char(hiredate,'mm') as mm from emp order by mm
by srinu_a47
Mon Mar 12, 2007 3:15 am
Forum: Oracle Databases
Topic: please help me on this.......(Oracle) Faq's
Replies: 2
Views: 1736

A cartesion product is generated if a join condection is omitted. Disadvantages of packages are 1)Unnecessary module loading. 2)Unable to load packages. 3)unable to compile large packages. 4)Lack of synonym support. if want any detail note see this give site http://books.google.co.in/books?vid=ISBN1...
by srinu_a47
Fri Mar 09, 2007 7:37 am
Forum: Oracle Databases
Topic: send me oracle peactice exercises
Replies: 0
Views: 1071

send me oracle peactice exercises

Plz send me the oracle sql & pl/sql
practice exercises and that exercises answers also
ok
by srinu_a47
Fri Mar 09, 2007 3:28 am
Forum: Oracle Databases
Topic: what is utl file's
Replies: 2
Views: 1744

what is utl file's

Plz Tell me what is the use of utl files in oracle 9i.
tell me the detail description on utl files.

How the utl files create.
by srinu_a47
Tue Mar 06, 2007 9:14 am
Forum: Oracle Databases
Topic: plz send me the query ans
Replies: 2
Views: 1710

plz send me the query ans

i cerated a table 'num' in that table i create a column 'sno'.
In that colum i enter the numbers 1 to 10.
my required output is
1 2 3 4 5 10 9 8 7 6

plz tell me how to display above output using sql
by srinu_a47
Mon Feb 26, 2007 9:12 am
Forum: Oracle Databases
Topic: IMP BOOKS FOR ORACLE BEGINNERS
Replies: 1
Views: 1799

sql-oracle corporation book
pl/sql-scott urman
by srinu_a47
Mon Feb 26, 2007 9:08 am
Forum: Oracle Databases
Topic: Toad application user help manual...
Replies: 3
Views: 2145

toad is just like Oracle Sql*plus tool It is user friendly It is used for both sql and plsql . It is used so many people. In toad table creation and constrains creation on table's is very easy. suggestion: ------------- If your are a biggner in oracle don't use toad. All experience persons know's wh...
by srinu_a47
Fri Feb 23, 2007 7:10 am
Forum: Oracle Databases
Topic: Counts of records in Different tables
Replies: 6
Views: 2624

select count(*) from emp
union all
select count(*) from dept;

the output is
COUNT(*)
---------
14
4