Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Answers
    23
    Views
    304,267

    SQL Re: Query to find structure of a table

    DESC <TABLE NAME>

    EX : DESC EMPDETAILS
  2. Answers
    3
    Views
    3,533

    Oracle Re: Record Size

    Try this query select length(div_code)+length(name) as "size" from pay
  3. Answers
    20
    Views
    44,752

    Oracle Re: Dual Table in Oracle

    Hi

    Try this query

    select greatest(10,15,20,30,) from dual

    greatest value
    -------------
    30
  4. Oracle Re: Creating a table by copying another table's structure

    Hi

    Try this following query

    create table <Newtablename > as select *from <Data table name >
    where <field_name> is null

    the above query copied only data structure from Data table name
  5. Oracle Re: Add a new column to a table and insert values

    The following commands used for adding new column and inserting values to the table.

    1. For adding column to the table

    ALTER TABLE emp
    ADD ( EMP_NAME VARCHAR(30));

    2. For inserting data...
Results 1 to 5 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