Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.10 seconds.

  1. Oracle Re: Inserting nextval after sequence has reached maximum value

    Hi,

    Oracle will definitely throw an error if the sequence exceeds the max value & cycle parameter is not set.
    The error will be ORA-08004,

    ORA-08004: sequence SEQ_TEST1.NEXTVAL exceeds...
  2. Thread: umask value ?

    by Innila
    Answers
    9
    Views
    8,354

    Unix/Linux Re: umask value ?

    Hi Suresh,

    umask value can be derived by adding up the permissions for the category & then subtract the value with 7.

    It will be clear with an example,

    The value for read, write & execute...
  3. Answers
    6
    Views
    1,392

    SQL Re: sql query help...

    Hi Suresh,

    Let me first understand your question...
    If the Benefits columns has multiple records like below,
    BENEFITS
    ----------------
    LOW
    MEDIUM
    HIGH
  4. Answers
    4
    Views
    24,980

    Oracle Re: ORA-12541: TNS:no listener

    Hi,

    Probably the listener was not running.
    Start the listener using "lsnrctl start" command in Unix and if its Windows OS start the listener service.
    If the listener is running & still u have...
  5. Answers
    6
    Views
    2,808

    SQL Re: shutdown and startup

    Hi,

    Since the definition alone is not very much clear, let me explain with an example in detail.
    As already given, Setting termout is used to display or suppress the output of sql commands if the...
  6. Oracle Re: How do I use a input variable inside like condition

    Hi Bharani,

    Use your query as follows,
    select empno, empname from empl where empname like '%'||v_empl||'%';

    This way you can use the input variable inside the like condition.
  7. Answers
    5
    Views
    15,307

    Oracle Re: How many types of views are there?

    Hi Barbie,

    I just have a small doubt reg the types of views which u have mentioned. Are they types of view of Oracle Database? :confused:
    As far as i know there are 2 types of views in Oracle,...
  8. Answers
    6
    Views
    2,808

    SQL Re: shutdown and startup

    2) what is 'set termout on' ?
    Setting termout is used to display or suppress the output of sql commands if the commands are run as a sql script.
    For example, if "set termout off" is given, it will...
  9. Answers
    7
    Views
    5,682

    Oracle Re: oracle 8i installation problem.

    Hi vmshenoy,

    Checked out the Oracle OTN site, if u want to go for Oracle 9i or 10g version, the database downloads are available.
    I'm not sure about the download conditions for 9i, but very sure...
  10. Answers
    1
    Views
    1,563

    Oracle Re: Code to search Customer name from Customer ID

    Hi Purna,

    Use this query,
    SELECT cust_name FROM CUSTOMER
    WHERE cust_id = ID;

    ID is the passed textbox value.
  11. Answers
    7
    Views
    5,682

    Oracle Re: oracle 8i installation problem.

    Oh! vmshenoy will be happy to hear that :-)
    Barbie, the installation was fine & is it working fine?
  12. Answers
    7
    Views
    5,682

    Oracle Re: oracle 8i installation problem.

    Hi vmshenoy,

    In Hostname, enter the Machine ID on which the oracle is been installed.

    TNSNAMES.ORA is very important for the database connectivity.
    A tnsnames.ora file provides the ability...
  13. SQL Re: How can I display the records in specific format

    Hi Anand,

    Formatting the Query results will satisfy your above format & the query is,



    break on deptno skip 0
    select deptno, empno, ename
    from emp
    order by deptno
  14. Answers
    15
    Views
    3,497

    SQL Server - Re: Delete duplicate record

    Rowid function is invalid in SQL Server.
    Rowid is the best way to eliminate duplicate records in Oracle & in SQL Server, the distinct function can be used.
  15. Answers
    5
    Views
    1,369

    Oracle Re: Learning DB admin in Oracle

    Hi aardvax,

    Its a nice idea to discuss about DBA activities. :cool:
    I think copying the data files is the fastest recovery method than importing the tables into the database.
  16. Answers
    5
    Views
    1,369

    Oracle Re: Learning DB admin in Oracle

    Hi aardvax,

    Physical structures are those files which are physically present in the Hard disk (physical space).
    Datafiles, control files, Redo log files, Archive log files, parameter files, etc...
  17. Answers
    4
    Views
    1,796

    Oracle Re: Retrieve the detail from emp

    Hi,

    Using Case Manipulation functions (Upper, Lower, Initcap) will be more appropriate for this validation.
  18. Answers
    3
    Views
    1,849

    Oracle Re: Required-interview questions for oracle

    Hi Reeta,

    I think the Geekinterview site will be very helpful, which has so many interview questions.
    Try this,
    Oracle Interview Questions

    All the very Best !!!
  19. Thread: SubQuery

    by Innila
    Answers
    3
    Views
    1,320

    SQL Server - Re: SubQuery

    Yeah true.
    Nice that u have mentioned the correction, James.
  20. Thread: SubQuery

    by Innila
    Answers
    3
    Views
    1,320

    SQL Server - Re: SubQuery

    Hi Chitra,

    A subquery is a select statement that is embedded in a clause of another select statement.
    A subquery is a SELECT query that returns a single value and is nested inside a SELECT,...
  21. Thread: Oracle OCP book

    by Innila
    Answers
    1
    Views
    5,184

    Oracle Re: Oracle OCP book

    Hi sudha,

    U can go for the following books for oracle 9i 1z0-007 exam,
    1) OCP Introduction to oracle9i: SQL exam guide by Jason Couchman
    2) OCA/OCP: oracle9i DBA fundamentals i study guide by...
  22. Answers
    15
    Views
    4,938

    Oracle Re: I want to remove - sign value

    Hi Rohit,

    Cant u update the row instead of creating a new table?
    What is the Oracle version your using?
  23. Answers
    15
    Views
    4,938

    Oracle Re: I want to remove - sign value

    Hi Rohit,

    Since u arent able to use abs function in a varchar column, then try converting the varchar into number & then identify the absolute value,



    The column ENO has a varchar2 datatype...
  24. Answers
    3
    Views
    1,158

    Oracle Re: what is consistency and intergrity

    Hi Saravanan,

    Data consistency means the validity & accuracy of the data available in the database.
    The consistency of the data is identified by the relevant changes made by the user's...
  25. SQL Re: Details of emp having the 788th highest salary

    I believe this command wont work in Oracle database.
    If im right, i think this command is compatible in MySQL database. Probably bvani can clarify regarding this.
Results 1 to 25 of 108
Page 1 of 5 1 2 3 4
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