Search:

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

Search: Search took 0.00 seconds.

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

    try with ALTER SEQUENCE and change the max val property or SET CYCLE property
  2. Answers
    5
    Views
    7,422

    General Re: SELECT query processing

    parse binds executes fetch
    this is the sequence of execution of any statement
  3. Answers
    11
    Views
    12,233

    General Re: How the joins work in SQL

    SELF JOIN : joins are made on the same table this is in use when u need to create a report on basis of join cond of data in the same table
  4. Answers
    5
    Views
    8,474

    Oracle Re: composite data type

    There are 2 types mainly used
    RECORD TYPE:-stores single row
    INDEX BY:-can hav multiple rows and column
    We use it to handle more than one values at a time
    THESE ARE USED MAINLY IN PL/SQL :)
  5. Oracle Re: How to create an index on a column while creating table

    It is not possible to create a index for a normal column at creation
    but
    Yes you can create for primary and unique key but its of no use the database define index for the 2 keys automaticly at...
  6. Answers
    5
    Views
    4,933

    Oracle Re: PL/SQL Question

    use this condition
    EXIT WHEN SQL%NOTFOUND
  7. Oracle Re: Getting data back from a Stored Procedure in Oracle

    Are u trying to get the data in an out variable or could u please post the code
  8. Oracle Re: Program to calculate SalesAmt of SalesTarget table

    What exactly is your question do u want to insert data or get the information from the table
  9. Oracle Re: I want to retreive only first record from the specified table

    This a for a general employee table but this will not giv right result if the employeeid has a null value...
    ------------------------------------------------------------------
    Select * from...
  10. SQL Re: Alternative for SELECT DISTINCT to query 2 million records

    Try creating an INDEX for the table
  11. Answers
    6
    Views
    4,748

    SQL Re: Dyamic SQL Queries

    IN oracle
    & is used for dynamic sub
    eg SELECT * FROM table
    WHERE last_name=&name
  12. SQL Re: Difference between VIEWS and SELECT statements

    VIEW is a virtual table by which we can create a virtual table with columns from diff tables
    It makes retrival of data from diff table lot more easier
  13. Answers
    2
    Views
    3,382

    SQL Re: hirerichal type database in SQL

    do u mean like creating a sructure like family tree
    then use
    START WITH
    CONNECT BY PRIOR
    this is supported by oracle
  14. SQL Re: Second highest number from a list of numbers

    CREATE OR REPLACE VIEW table_view
    AS
    SELECT col1,rownum AS level FROM table
    ORDER BY col1;
    THIS query genertes col1 ordered by col1
    and level wld 2 for 2nd higest value,
    NOW
    SELECT * FROM...
  15. SQL Re: which is more suitable IN or EXIST in SQL?

    EXIST would a faster option because IN has return data from table where as EXIST needs to return only a literal which makes it much faster
  16. Answers
    20
    Views
    36,878

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

    No u cannot insert a new column in middle of table but to the last is possible with a alter command
  17. Thread: Query

    by soorajsk_84
    Answers
    4
    Views
    4,590

    SQL Re: Query

    CREATE TABLE tablename
    AS
    SELECT * FROM tablename
    WHERE ( a cond that is returns 0 rows)
  18. SQL Re: Difference between BETWEEN and AND query?

    Between- It returns data between two sets of values
    eg:between 10 AND 20 mean returns data between 10 and 20 inclucing 10 and 20
    AND:and returns value when two conditions are satisfied
Results 1 to 18 of 18
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