Search:

Type: Posts; User: nehrumosuru; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.23 seconds.

  1. Answers
    8
    Views
    4,021

    Oracle Re: UNION vs UNION ALL

    Union - It will show only distinct rows

    Union all - I will show all rows with duplicate rows
  2. Answers
    0
    Views
    2,636

    Windows Windows 2000 Server

    We are using windows 2000 server with oracle 10i. Now some showing the server message is
    " A Disk that is part of a fault - tolerant volume can no longer be accessed "

    Why these message is...
  3. Answers
    11
    Views
    3,232

    Re: How to compare two tables

    What tables want to compare data give correct table names ?
  4. Answers
    2
    Views
    1,981

    Oracle Add Two queries

    Hi

    How to Add two queries output ( result ) in single table in oracle. and which function used
  5. Answers
    3
    Views
    2,278

    DB2 - Re: How to use stored procedures in db2

    Create procedure < name > ( parameters ) as
  6. Answers
    23
    Views
    101,919

    SQL Re: Query to find structure of a table

    DESC <TABLE NAME>

    EX : DESC EMPDETAILS
  7. Answers
    1
    Views
    1,146

    Space decrease in Oracle 9i

    We are using Oracle 9i , Automatically space decrease in D Drive ( Database Drive ) day to day.
    and we are working daily in data base small works.
    How to increase space in D drive , pl. give any...
  8. Thread: 9i and 10g

    by nehrumosuru
    Answers
    1
    Views
    1,142

    Oracle 9i and 10g

    What is difference between Oracle 9i and oracle 10g ?
  9. Answers
    1
    Views
    920

    Oracle Sql and Mysql

    What is difference between SQL and MySQL ?
  10. Oracle Re: i want to know about Hyperion? uses of Hyperion

    The Oracle Hyperion Planning. The Oracle Hyperion Planning platform enables usage of standard planning features, functions and interfaces .

    Regards

    M.N.Babu
  11. Answers
    7
    Views
    1,548

    Oracle Re: Need urgent help with oracle password

    Hi,

    Please try User name : SCOTT,
    Pass Word : TIGER ( OR SMALL LETTERS )
  12. Thread: Sub Report

    by nehrumosuru
    Answers
    1
    Views
    929

    Oracle Sub Report

    Hi,
    Any possible Add Sub report in D2k , please give advise how to Add Sub Report in D2k .

    With regards

    M.N.Babu
  13. Answers
    4
    Views
    1,154

    Oracle Re: Commit and Post

    Commit command used to permanent saved in database
  14. Answers
    4
    Views
    2,390

    MySQL Re: Where Clause with Group by and Order by

    SELECT dept, sum(net)
    FROM emp
    WHERE net < 10000
    GROUP BY dept
    HAVING AVG(net) > 5000
    ORDER BY dept;
  15. Answers
    3
    Views
    1,238

    Oracle Re: how to get the data..........

    What is your requirement fields from tables , pl send tables and field names
  16. Answers
    11
    Views
    3,666

    Re: distance from home

    Distance from home 13 Km

    Distance = Sqrt(12*12)+(5*5)
    Distance = Sqrt (144+25)
    Distance = Sqrt (169)
    Distance = 13
  17. Oracle Re: How to capture client machine IP address from Oracle 10g application server?

    use this command to capture ip address

    select sys_context( 'userenv', 'ip_address' ) from dual
  18. Answers
    16
    Views
    3,036

    Oracle Re: what is oracle

    oracle is database(RDBMS),it provides database to different companies.that means maintaining all the data in a place and providing security and other authentications to the data as per user and...
  19. Answers
    3
    Views
    1,185

    Oracle Re: Record Size

    Try this query select length(div_code)+length(name) as "size" from pay
  20. Answers
    20
    Views
    37,041

    Oracle Re: Dual Table in Oracle

    Hi

    Try this query

    select greatest(10,15,20,30,) from dual

    greatest value
    -------------
    30
  21. Oracle Re: Creating a table by copying another table's structure

    Hi

    Try this following query

    create table <Newtablename > as select *from <Data table name >
    where <field_name> is null

    the above query copied only data structure from Data table name
  22. Answers
    20
    Views
    3,963

    Oracle Re: pls answer to this sql query

    Hi

    Try this query

    Select empid,empname,managername
    from emp, emp1 ( another table name )
    where empid =managerid

    U have any doubt please see once in self join condition
  23. Answers
    2
    Views
    1,121

    Oracle Re: Find out Duplicate names in a table

    SELECT NEW_CODE,NAME,COUNT(*) FROM Table name
    GROUP BY NEW_CODE,NAME
    HAVING COUNT(*) >1
  24. Oracle Re: using results of one subquery in another subquery

    SELECT ename, job, sal
    FROM emp
    WHERE job = (SELECT job FROM emp WHERE ename = 'SCOTT')
    AND sal = (SELECT sal FROM emp WHERE ename = 'SCOTT');


    - two sub queries are used here

    - one...
  25. Answers
    2
    Views
    1,121

    Oracle Find out same name double times

    Dear Sir,

    The same name displays Double and multiple times in a single table.

    Pl.send me the query how to find out the double and multiple names in a single table.
Results 1 to 25 of 28
Page 1 of 2 1 2
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact