Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.60 seconds.

  1. Answers
    2
    Views
    1,222

    SQL Re: finding the duplicate records

    @venkat,

    In oracle SQL,

    The following query will resolves your problem


    delete from delete_table where rowid not in (select max(rowid) from delete_table group by MEMBER,AGE );
  2. Oracle Re: How to capture client machine IP address from Oracle 10g application server?

    @Yajnas,

    Query to retrieve remote client IP adress and local client IP adress.


    select utl_inaddr.get_host_address(host_name), host_name from v$instance;

    Query to retrieve server ip address
  3. Thread: sql querry

    by ecearund
    Answers
    8
    Views
    2,942

    SQL Re: sql querry

    @sumangala,

    To find second largest salary of an employee in a table.


    SELECT * FROM
    ( SELECT e.deptno , e.ename , e.sal , dense_rank() OVER ( ORDER BY max(e.sal) DESC) Highest_Salary
    FROM...
  4. SQL Re: Please answer this question as soon aaaaaaaaas possi

    @rajabose, why need to go for stored procedures, we can achieve this, by sql analytic functions. For ur reference : the above sql analytic functions retrieves the details of orderwise highest paid...
  5. Answers
    9
    Views
    2,649

    Oracle Re: ORA: 12541 - TNS-no listener - Issue

    @karthizen,

    Please validate the points mentioned in the following Link

    Refer_Here

    I believe, those points mentioned in the above link will guide u properly.
  6. Answers
    9
    Views
    2,649

    Oracle Re: ORA: 12541 - TNS-no listener - Issue

    @karthizen,

    Please validate the points mentioned in the following Link

    ORA-12541 TNS no listener

    I believe, those points mentioned in the above link will guide u properly.
  7. Answers
    9
    Views
    2,649

    Oracle Re: ORA: 12541 - TNS-no listener - Issue

    @karthizen,

    Cause: The connection request could not be completed because the listener
    is not running.
    Action: Ensure that the supplied destination address matches one of
    the addresses used by...
  8. Answers
    7
    Views
    9,202

    Oracle Re: Oracle Username n Password

    @risi21,

    1. Try to Check the listener whether is running or not(lsnrctl status).
    If not, start the listener.
    lsnrctl start

    2. If the DB is local to the machine then try to setting...
  9. Thread: Row count

    by ecearund
    Answers
    3
    Views
    1,580

    Oracle Re: Row count

    @susarlasireesha,


    There are n number of ways
    1. Count(*)
    2. Count(1)
    3. Count(rowid)
    4. Column num_rows in user_tables & go on.

    count(*) and count(1) - Almost the same
  10. Answers
    1
    Views
    804

    Oracle Re: Trigger Problem

    @sanjeev,

    Dear, U have missed out the semi-colon at the end of insert statement,
    thats why some error may occur.

    Just execute the following stuff



    create or replace trigger update_trigger
  11. Answers
    5
    Views
    1,452

    Oracle Re: Date Conversion ...

    Hai susarlasireesha,

    Its Fine.
    By using to_date function, not possible to convert N number of different date format to required format, i believe.

    But as per your requirement, "alter session"...
  12. Answers
    5
    Views
    1,452

    Oracle Re: Date Conversion ...

    Hai susarlasireesha,

    to_date function will do the Functionality whatever u asked for.

    For eg.
    select to_date('25-june-2009','dd-mm-rrrr') as Conv_Date_Format
    from dual;

    Conv_Date_Format...
  13. Answers
    3
    Views
    1,383

    SQL Re: Get Column values as Rows

    Hai jyothi,

    If u execute something like this
    select ename||',' from emp;
    u get the ename appended with ','
    But as per ur requirement u need to convert the entire column result into row with...
  14. Thread: sequences

    by ecearund
    Answers
    1
    Views
    1,116

    SQL Re: sequences

    Hai imtiazali,

    Now u have two Options as far as I know.

    Option 1:
    Drop the sequence.Truncate the table and recreate the sequence and do the insert process .

    Option 2:
    Alter the same...
  15. Answers
    1
    Views
    1,034

    Oracle Re: How to improve performance of fetch??

    Hai souji,

    Try to use the LIMIT clause, bulk collect say 100 to 1000 rows .
    process them, bulk insert them, get the next 100/1000 rows for fetching.
  16. Answers
    2
    Views
    1,956

    Re: How to attach timestamp.......

    @Rijus,

    yes Rijus, it is not possible..It will throw some errors.
    Let try something like the following script..

    echo "Enter Input File: "
    read FILE
    copyfile=`basename ${FILE}`
    copyfile=`cp ...
  17. Answers
    2
    Views
    2,273

    Unix/Linux Re: unix shell script........

    @Rijus,

    Try to get the username/password/oracle_sid in some variable as Input.
    Then
    sqlplus -s $(variable1)/$(variable2)@$(variable3) <<END
    set serveroutput on size 10000
    declare
    a date;...
  18. Answers
    7
    Views
    12,320

    Unix/Linux Re: 'vi' - 'touch' Commands Difference

    @Rijus,

    Vi - a programmers text editor.
    It can be used to edit all kinds of plain text. It is especially useful for
    editing programs.
    Mainly used by Unix programmers.
    Nowadays, knowing to...
  19. Answers
    1
    Views
    1,015

    Unix/Linux Re: linux mail sending

    Hai Murali,

    For example if you want to send a file from a directory /home/xxx/ named "vvv.sql" to xxx@yahoo.co.in using the command "mailx"

    Then following is the syntax.
    mailx -s "vvv.sql"...
  20. Oracle Re: Logical Mechanism of Trigger / How DB thinks about Trigger

    @Prasad,

    Dear, Instead of knowing the answers for some of the Junk topics regarding trigger. You can refer the Oracle documentation, that will guide U alot.
    Also it will answer all of your...
  21. Oracle Re: Logical Mechanism of Trigger / How DB thinks about Trigger

    @Prasad

    For your Knowledge,
    Link1

    Link2
  22. Answers
    3
    Views
    8,098

    Oracle Re: How to find the unused tables in a schema

    @Rijus,

    see U can analyze somehow using the Following Views.
    user_tab_modifications
    dba_tab_modifications
    all_tab_modifications

    These Views will describes tables accessible to the current...
  23. Answers
    7
    Views
    9,757

    Oracle Re: Diff b/w If Else, Case, Decode

    Hai gupta, the decode and case functions are used within the oracle database to transform data values for one value to another. The use of decode for counting values case functions are more flexible...
  24. Answers
    7
    Views
    9,757

    Oracle Re: Diff b/w If Else, Case, Decode

    Refer Here
    Link1
  25. Answers
    3
    Views
    1,097

    Oracle Re: Difference betn Dba and developer

    @Sanjay,

    Refer here
    Difference between Database Administrator and Developer? - Toolbox for IT Groups
Results 1 to 25 of 79
Page 1 of 4 1 2 3 4
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