Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Answers
    4
    Views
    3,518

    Oracle Re: Oracle 9i Installation

    At the time of installation of oracle 9i, it will prompt you for type of databse selection, which is to be created. At this time you can choose, 'Software only' option instead of database type. So...
  2. Answers
    4
    Views
    3,518

    Oracle Re: Oracle 9i Installation

    what exactly you want?
  3. Answers
    5
    Views
    12,244

    Oracle Re: Find IP Address of connected Client

    hi all

    will it work after shutdown of my database? i mean.......one person connected and disconnected to my database.........next i shut it down....and started it up...............still i want his...
  4. Answers
    5
    Views
    12,244

    Oracle Re: Find IP Address of connected Client

    hi all
    @sirisha

    thanx4 reply
    your 2 methods shows the current session details means IP address of the machine, if it is connected right now. but i told that.....i want IP address of the machine,...
  5. Answers
    7
    Views
    8,102

    Oracle Re: Celebrate Birthday Of Employees Query

    hi

    @krishna
    i missread the question actually.......


    any way RRRR has very usefull than YYYY in some situations........any one could tell this? i think SQL programers know this concept.

    ...
  6. Answers
    2
    Views
    15,995

    Oracle Re: Tip of the day - A new thread

    hi

    Tip of the day thread already exist. that too startrd by u only.....
    u can use that na...

    Jaya
  7. Answers
    7
    Views
    8,102

    Oracle Re: Celebrate Birthday Of Employees Query

    select * from emp where to_char(dob,'ddmmRRRR')=to_char(sysdate,'ddmmRRRR')

    Jaya
  8. Answers
    8
    Views
    3,672

    Oracle Re: Tip of the day

    hi
    Tip of the day::)


    to minimize the fragmentations and improve query response time related to one particular table just reorganize the table in the following way:


    SQL> alter table <...
  9. Answers
    5
    Views
    12,244

    Oracle Find IP Address of connected Client

    hi

    suppose one client machine is connected to my oracle server, and after perform 1,2 transactions he is disconnected. how to find his IP address?


    If we want to monitor upcoming...
  10. Answers
    8
    Views
    3,672

    Oracle Re: Tip of the day

    hi

    y not we can, can u post the returned error?

    Jaya
  11. Answers
    3
    Views
    3,415

    Oracle Re: Sequences Reg.

    hi

    You are right, when we use cache with sequences, we miss some values bcoz of instance shutdown and 'age out' of shared pool ( which contains the cached sequences ).

    here is some trade off....
  12. Answers
    4
    Views
    3,776

    Oracle Re: Oracle 10g and Fedora

    hi

    who said that fedora will not support oracle 10g...
    it will work nicely.....

    Jaya

    i am raising old topics bcoz lack of sufficient new stuff...
  13. Thread: dba qs

    by jaya_geek
    Answers
    3
    Views
    3,260

    Oracle Re: dba qs

    hi

    STARTUP FORCE

    it will just switch off the database as it is ( without checkpoint) and do normal startup.


    we can use this method in special cases, like ... if database giving error while...
  14. Answers
    6
    Views
    4,150

    Oracle Re: Unlock Problem

    hi

    in any any version of oracle, you can alter sys from system.
    i believe you could solve your problem.

    Jaya
  15. Answers
    1
    Views
    4,843

    Oracle Re: Installing Oracle 10g database in Linux

    hi you have to change the shared_pool_size parameter in your init.ora file. It may find in your $ORACLE_HOME/dbs directory.


    Jaya
  16. Answers
    8
    Views
    3,672

    Oracle Re: Tip of the day

    use oracle wrap utility to encrypt your procedures and packages. But can't wrap triggers.

    Jaya
  17. Answers
    9
    Views
    6,888

    Oracle Re: Creating a folder with sysdate

    hi all

    well it's working...thank you susarlasireesha


    what i understood is

    md %date:~7,2%%date:~4,2%%date:~10,4%

    is combination of 3 parts
  18. Answers
    9
    Views
    6,888

    Oracle Re: Creating a folder with sysdate

    hi
    @susarlasirisha

    can you explain your 6 steps...i am unable to understand :confused:why you created date in one file and copy that in another finally call that one. I am confused.

    DATE /t...
  19. Answers
    6
    Views
    4,801

    Oracle Re: Kill a session from client machine

    hi all

    some one asked questions, and some others giving solutions. but final result ( problem rectified or not ) is not here. If any one could solved the problem please post that here...then new...
  20. Answers
    2
    Views
    3,153

    Oracle Re: Importing Data

    hi
    vice versa possible? i mean is possible to import into 9i which is exported from 10g? i never tried...but i think we can't.

    Jaya
  21. Answers
    3
    Views
    3,026

    Oracle Re: which one is the better option?

    hi

    yaa table level trigger is better. even form level trigger also come to oracle level to do that. oracle trigger is there 2 do that...why do we go for form level again.....i think so.

    Jaya
  22. Answers
    3
    Views
    8,709

    Oracle Re: Call export from PL SQL

    hi all

    @jit_mum

    harry asked for how to export data from plsql procedures. means how to invoke the process what we do in command prompt ( exp scott/tiger@dba1 file=new.dmp .....like that ) from...
  23. Oracle Re: Can anyone suggest me how to prepare for ORACLE certification

    hi you can go for OCA/OCP dumps

    which depends on the version of the oracle.

    in case 9i

    1) Sql/PLSql
    2) Fundamentals - 1
    3) Fundamentals - 2
    4) Performance Tuning
  24. Thread: View

    by jaya_geek
    Answers
    6
    Views
    3,624

    Oracle Re: View

    hi all

    @susarlasireesha

    well, it's ok, but can u explain what is escape and it's use?

    we should know the use of quotes with coloum. since we can't create a coloum name with spaces....i...
  25. Answers
    4
    Views
    8,132

    Re: File Handling in C

    hi

    i think , you are trying to build a C/C++ program to handle a database, right? then

    are you expecting only one company? then

    just create 2 binary file to handle database, one is for...
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