Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.26 seconds.

  1. Answers
    10
    Views
    4,531

    Oracle Re: How to add values to other columns

    Hello Friend,

    Just go through this link once.

    [B]Database Design - DDL & DML[BR]

    I hope you will get your answer here.

    Have a pleasant time.
  2. Answers
    4
    Views
    13,345

    Re: JDK 1.5 Setup

    Dear Suresh,

    Thank you for the suggestion you posted.

    I tried the third link also but its not working.
    It shows file size more than 50 MB online,
    But once downloading, it is showing file size...
  3. Answers
    4
    Views
    13,345

    JDK 1.5 Setup

    Dear All,

    I need JDK 1.5 setup.
    Kindly suggest how to get the same.
    I tried this link http: // java . sun . com/javase/downloads/index_jdk5 . jsp
    But its giving Error in when i am running the...
  4. SQL Re: Query to find all cars sold by salesman

    Dear gangu_d,

    Please provide sample data.
    It will be easy for our team members to help you better.
    Also send the structure if possible.

    Have a pleasant time.
  5. Answers
    8
    Views
    8,433

    SQL Re: Retrieve last record

    Dear Krishna,

    Thank you for your reply.

    Yes you are right, we can get the output without
    WHERE ROWNUM < (SELECT COUNT(*)+1 FROM TABLE_NAME

    Actually i was first selecting all rows using the...
  6. Answers
    8
    Views
    8,433

    SQL Re: Retrieve last record

    Dear Friend,

    Try this,

    SELECT * FROM (
    SELECT ROWNUM RN,A.* FROM TABLE_NAME A WHERE ROWNUM < (SELECT COUNT(*)+1 FROM TABLE_NAME) )
    WHERE RN = (SELECT count(*) FROM TABLE_NAME)

    Have...
  7. Answers
    10
    Views
    4,527

    Oracle Re: Grant Privileges

    Dear Krishna2007,

    Try creating the Database Link from any of your team members System
    If its working there then copy the TNSNAME to your System.

    Is this the same Database Link or you are...
  8. Answers
    2
    Views
    2,317

    Oracle Re: Log Generation - JSP Application

    Dear susarlasireesha,

    Thank you foryour kind reply.

    I already the link that you sent. But i need to stop the log generation.

    How can i do that. Please help me out.

    Have a pleasant time.
  9. Answers
    2
    Views
    2,317

    Oracle Log Generation - JSP Application

    Dear All,

    In our unit, our stores department used to conduct online auction of scrape materials, every 3 months. Now the problem that i am facing is that the system is generating log in the at the...
  10. Answers
    5
    Views
    2,783

    Oracle Re: A Query Doubt

    Dear Krishna,

    Kindly try this query and reply. I have tuned it at my end.
    I hope it will not take much execution time.

    Have a pleasant time
  11. Answers
    2
    Views
    2,440

    Oracle Grant

    Dear All,

    I need to grant only SELECT privilege on entire Database to a particular user
    with a single GRANT statement.
    Kindly suggest your opinions regarding the same.

    Have a pleasant time.
  12. Answers
    1
    Views
    1,481

    Oracle Useful Oracle Apps Links

    Dear All,

    Kindly send links that contains details regarding Oracle Apps.

    Have a pleasant time.
  13. Answers
    10
    Views
    4,527

    Oracle Re: Grant Privileges

    Dear Krishna,

    Check your TNSNAME file in C:\ORANT\NET80\ADMIN\TNSNAMES.ORA

    If you sre unable to find the ORANT folder in C:\, Search for TNSNAMES file.

    Now once you get the file, check...
  14. Answers
    10
    Views
    4,527

    Oracle Re: Grant Privileges

    Dear krishnaindia2007,

    Try this

    CREATE DATABASE LINK db_link_krk
    CONNECT TO cmsjan IDENTIFIED BY "cmsjan"
    USING 'orion.ssapl01'

    Provide Password in Double Quotes and Connection String in...
  15. Answers
    10
    Views
    4,527

    Oracle Re: Grant Privileges

    Dear krishnaindia2007, you cannot grant privileges dierctly from one database to the other by simply using username and connection string. If you want to give all privileges on a table, to different...
  16. Answers
    1
    Views
    1,601

    Oracle Interview Questions for DBA's

    Dear All,

    Please refer the DOC file to get details regarding the Interview Questions that are asked to DBA's

    Have a pleasant time
    :)
  17. Answers
    1
    Views
    2,629

    Oracle Refer the attached DOC file

    Dear All,

    Please refer the DOC file to get some details about SQL


    Have a pleasant time.

    :)
  18. Oracle Try this: Number to Words Conversion

    Dear All,

    Spell out numbers to words

    select decode( sign( &num ), -1, 'Negative ', 0, 'Zero', NULL ) ||
    decode( sign( abs(&num) ), +1, to_char( to_date( abs(&num),'J'),'Jsp') )
    from...
  19. Answers
    2
    Views
    1,926

    Oracle Try this to Test for Leap Year

    Dear All,

    Test for Leap Years

    select year,
    decode( mod(year, 4), 0,
    decode( mod(year, 400), 0, 'Leap Year',
    decode( mod(year, 100), 0, 'Not a Leap Year', 'Leap...
  20. Answers
    1
    Views
    1,434

    Oracle Tips of the Day

    Dear All,

    Select the Nth highest value from a table

    select level, max('col_name') from my_table
    where level = '&n'
    connect by prior ('col_name') > 'col_name')
    group by level;

    Have a...
  21. Answers
    5
    Views
    2,892

    SQL Re: fetch rows fastly

    Dear susarlasireesha,

    Try query optimizer HINTS.
    You can choose between Default, /*+ CHOOSE */, /*+ RULE */, and /*+ FIRST_ROWS */.

    I hope this will help you solving your query.

    Have a...
  22. Answers
    5
    Views
    2,592

    Oracle Re: A Query Doubt

    Dear krishnaindia2007,

    ROWNUM is a PSEUDO Column and it is used only when you are querying data from table directly i.e. when you are using table name after FROM clause. In your second query you...
  23. Answers
    4
    Views
    2,115

    Oracle Re: How to insert values

    Dear RupeshDharne,

    If you want to do this using trigger then it will not possible to do the same
    because while writing trigger on a table, you cannot use the DML on the same
    table. It will give...
  24. Answers
    4
    Views
    2,262

    SQL Re: Sum giving different results

    Dear Bhutyaa,

    Both the case is different

    Suppose you have the following two columns:

    a b
    ___
    1 2
    3 4
  25. Answers
    1
    Views
    1,430

    Oracle Tips of the Day

    Dear Team,

    Good Morning

    Display Database version, installed options and port string

    select banner
    from sys.v_$version;

    select ' With the '||parameter||' option'
Results 1 to 25 of 56
Page 1 of 3 1 2 3
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