Search:

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

Search: Search took 0.09 seconds.

  1. Answers
    2
    Views
    1,287

    Oracle Re: Executing anonymous PL/SQL block in Forms !!

    Begin insert into emp values (10, 'debasis'); end;
  2. Answers
    2
    Views
    1,287

    Oracle Executing anonymous PL/SQL block in Forms !!

    I want to execute an anonymous PL/SQL block, stored inside a column, in Forms.

    Please help me out with the solution by both using and not using "EXECUTE IMMIDIATE". :eek:
  3. Oracle Re: How to capture client machine IP address from Oracle 10g application server?

    Hi,

    Oracle - It is the Software who provides you the facility to use database as Oracle9i, 10g (These are the different versions of Oracle database).

    Oracle Apps: Oracle provided frontend...
  4. Answers
    3
    Views
    3,791

    Oracle Re: types of joins in Oracle9i with ex.

    The basic defination is "Whenever you are fetching records from more than one table, the condition or link you are providing between tables is known as JOIN". And if you not using any condition or...
  5. Thread: character

    by Yajnas
    Answers
    2
    Views
    911

    Oracle Re: character

    The records being stored insdie the Oracle database, are case sensitive (i,e. data inside tables). Three types of conversions are there to change the case of any character data 1. LOWER (oracle) 2....
  6. Oracle Re: How to capture client machine IP address from Oracle 10g application server?

    Thank You all of you for your valuable suggetions.

    I got the solution by attaching Webutil.pll and Webutil.olb in my form. WEBUTIL_CLIENTINFO.GET_HOST_NAME, WEBUTIL_CLIENTINFO.GET_IP_ADDRESS are...
  7. Oracle Re: How to capture client machine IP address from Oracle 10g application server?

    But its not working inside a Form builder. Its replying the server ip only. :confused:
  8. Oracle Re: How to capture client machine IP address from Oracle 10g application server?

    Can anyone give any other solution in this regard ?
  9. Oracle Re: How to capture client machine IP address from Oracle 10g application server?

    Thanks Debasis.

    I have tried this in database tools, its returning system ip. But when I use this particular statement in FORMs and trying to capture the value it is returning Application Server...
  10. Oracle Re: How to capture client machine IP address from Oracle 10g application server?

    But if I am using this statement.. in application it is giving me the ip of application not of the local machine.
  11. Oracle How to capture client machine IP address from Oracle 10g application server?

    Hi,

    I want to capture ip address of the machines, that are logging into my oracle 10g application. :confused:
    I tried with SYS_CONTEXT, UTL_INADDR but these two are giving application ip and...
  12. Thread: sql

    by Yajnas
    Answers
    5
    Views
    1,253

    SQL Re: sql

    In my words I say SQL as Simple Query Language. As much as you practise and remember the key words, that much easy it became. Since nothing to develop newly, only use your logic and those Oracle...
  13. Answers
    1
    Views
    6,968

    Oracle Re: FRM-40600 Record has already been inserted.

    Thanks.

    Got the solution by changing the block enforce primary key property to "No".
  14. Answers
    1
    Views
    6,968

    Oracle FRM-40600 Record has already been inserted.

    Dear All,

    Please give me some solutions on the following error -:

    While I am saving a record, I am getting the "FRM-40600 error". I have unique combination in my primary key, also I tried the...
  15. Answers
    1
    Views
    5,065

    Oracle Re: How to create LOV

    Hi,

    To create a LOV in Form builder you need to first create a record group (which contains the SQL query and fetches the records to be displayed in the LOV). Now add a LOV and map this record...
  16. Answers
    5
    Views
    6,517

    Oracle Oracle Package.function

    Hi,

    Can any one please reply back the answer to the question that " If u call a package.function name then what will get loaded in memory?".:rolleyes:


    Regards
    Sanjay
Results 1 to 16 of 16
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