Search:

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

Search: Search took 0.09 seconds.

  1. Answers
    20
    Views
    4,664

    Oracle Re: pls answer to this sql query

    Hi, in emp table you don't mentioned the empname column. Only mentioned empid. If you using self join then its possible. But as per u r questeen it is not possible.... Regards, sambu.....
  2. SQL Re: A Simple Query (If any 1 can answer) PLEASE !!

    1. Instr finds the neumeric of a named character.
    For ex: select instr('sambu','m') from dual.
    You will getting the answer is 3.


    SQL> select instr('sambu','m') from dual;

    INSTR('SAMBU','M')...
  3. Answers
    3
    Views
    6,111

    Oracle Offline Temporary TableSpace

    Hi All ! I am created a tablespace as well as a temporary tablespace. Also I am created a default temporary tablespace. My questeen is "Temporary tablespace can be deleted or not."

    And one more...
  4. SQL Re: How to use revoke and grant in sql commands

    Try this..
    grant select on sutdent2 to satish;
    revoke select on student2 from satish;
  5. Thread: sql

    by nathsambu
    Answers
    3
    Views
    1,487

    SQL Re: sql

    Its very simple..try this..

    select to_char('date1' , 'date2') from tablename;
  6. Answers
    3
    Views
    1,818

    SQL Re: save some text data in SQL

    Its very simple
    after login in sql,
    sql>spool d:sambu\txt and then press enter.
    Now spool is on and before you logoff you need to spool off.
    spool off;
    All date you can see in the D drive with...
  7. Answers
    12
    Views
    39,333

    Oracle Re: Add a new column to a table and insert values

    Alter table dept
    add (ename varchar2(10));

    For insert the value in ename colomn,

    Insert into dept (ename)
    value('Deepa');
    Try this. I think you will getting u r answer.
  8. Answers
    20
    Views
    24,773

    SQL Re: Insert new column in the middle of a table

    Insert a new colomn in middle of the table is not possbile.
  9. SQL Re: Can Select statement be used along with Update statement?

    Yes , You can use..
  10. SQL Re: Delete duplicate records without using "rowid"

    I think this is not possible in Oracle.
  11. Answers
    371
    Views
    231,772

    Re: Oracle Interview Questions Free E-Book

    Thanx a lot.
Results 1 to 11 of 11
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