Search:

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

Search: Search took 0.07 seconds.

  1. Answers
    5
    Views
    3,625

    Oracle Re: loss of parameter file

    you have to manually recreate the parameter file.
    just copy and edit the sample parameter file given in the following location
    "%Oracle_home%\dbs\" according to instance requirements.

    you need...
  2. Oracle Difference between alter system and alter database.

    can anyone give the Difference between alter system and alter database stmt.
  3. Thread: view

    by raj_java_j2ee
    Answers
    4
    Views
    1,339

    Oracle Re: view

    1.in case if your using a two or three tire architecture or more and if the select stmt spans many lines a view can be created to reduce the network load

    2.it can also be used to hide the logic of...
  4. Answers
    4
    Views
    1,168

    SQL Re: Procedure Source

    You can get the source of a view,function,procedure using
    syscomments table in sql server.
  5. Oracle Re: When you start an Oracle DB which file is accessed first?

    Correction from previous post:
    the directory is Oracle_Home\database and not Oracle_Home\dbs

    the first file which is accessed when an Oracle DB is opened is in the following order

    1.firstly...
  6. Answers
    2
    Views
    1,143

    Oracle Re: identity available in oracle

    Instead of identity Oracle has provided sequence
    sequence will auto generate numbers.

    create the sequence using the basic syntax

    CREATE SEQUENCE seq1
    MINVALUE 1
    START WITH 1
    ...
  7. Oracle Re: How to alter the or drop the default constraint in oracle sql

    While specifying a constraint you can give the constraint a name.
    but
    if you do not specify any name for the constraint
    Oracle will generate a constraint name of the format
    SYS_Cn

    were n is...
  8. Answers
    2
    Views
    5,424

    Oracle Re: Maximum Datafiles

    The number of data files in oracle database is controlled by the initialization parameter
    DB_FILES

    setting this value too high can cause DBWR issues.

    before 9i maximum no of datafiles in a...
  9. Answers
    4
    Views
    4,236

    Oracle Re: Index not picking up

    Analyze the table and index.
    and then check it.
  10. Answers
    6
    Views
    1,455

    Oracle Re: Unlock Problem

    How did the sys account got locked.

    Have you assigned any profile to sys account.
  11. why i am getting an error while calling a constructor from another constructor

    class another_cons
    {
    int x,y;
    another_cons(int a,int b)
    {
    x=a;
    y=b;
    }
    another_cons()
    {
Results 1 to 11 of 12
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