Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by KULJEETSINGH

  1. KULJEETSINGH

    Media Recovery Needed

    if database is archive mode then issue recover datafile 1; it will solve u r problem.
  2. KULJEETSINGH

    as an DBA - how to log in as the user without knowing the password?

    Connect from sys and see its objects do not need to login to his a/c
  3. KULJEETSINGH

    Question regarding Iz0-031 (PMON or SMON?)

    i think PMON rolls back the user's current transaction PMON releases the table and rowlocks held by the user session read this The process monitor (PMON) performs process recovery when a user process fails. PMON is responsible for cleaning up the database buffer cache and freeing resources that...
  4. KULJEETSINGH

    which is harder--Fundamental-II or Performance Tuning

    SORRY i have not done any class or ocp exams. but i have experience in oracle. so my suggestion that you will takes performance tuning class. ocp exams are not so hard IF u will prepair well. study lots and practice on u r pc (use oracle on nt and linux). and do u have any real experience in...
  5. KULJEETSINGH

    which is harder--Fundamental-II or Performance Tuning

    GO FOR PERFORMANCE TUNING
  6. KULJEETSINGH

    Installing 9i AS .....?

    yes install database seprately for oracle 9i release 1 use oracle 8i database for oracle 9i release 2 use oracle 9i database
  7. KULJEETSINGH

    if statement inside a select statement

    use decode function it works like if elsif else.
  8. KULJEETSINGH

    Syntax of run_report_object

    SORRY USE ONE MORE LINE BEFORE END; report_JOB_ID:=run_report_object(report_id); THIS LINE USE AT THE END (BEFORE END STATEMENT)
  9. KULJEETSINGH

    Syntax of run_report_object

    HI USE THIS SYNTAX declare report_id Report_Object; report_job_id VARCHAR2(100); BEGIN report_id:= find_report_object('report_node'); ******************************* --NOTE <REPORT_NODE> IS NOT A REPORT NAME --IT IS A REPORT OBJECT IN OBJECT NAVIGATION OF FORM UNDET - --IT U GIVE REPORT...
See more

Part and Inventory Search

Back
Top