Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.25 seconds.

  1. Answers
    3
    Views
    1,610

    SQL Re: Check Constraint

    check this table creation ..check constraint also validates table data ....Even no need to write trigger also..

    Create Table tab1(empno Number,Position Varchar2(100),sal Number,
    Constraint check1...
  2. Answers
    4
    Views
    2,215

    Oracle Re: pl sql program

    just check below procedure ...

    Declare
    cn_string Constant Varchar2 (4) := 'ABCD';
    Begin
    For i In 1 .. 4
    Loop
    For j In 1 .. 4
    Loop
    For k In 1 .. 4
  3. Answers
    1
    Views
    856

    Oracle Re: Sub Report

    Use additional layout wizard ...
  4. Answers
    1
    Views
    1,906

    Oracle Re: PL SQL FORALL LOOP Statement

    Just check this sample code ...
    Declare
    type emp_details is table of varchar2 (4000) index by binary_integer;
    emp_details_tab emp_details;
    stat varchar2(4000);
    begin stat := 'select...
  5. Oracle Re: Create Table along with constraints

    No not possible, if u create table 'create table a as select col1,col2 from b '
    then only not null condkition will copy from old table to new table ...
    no other constraints will copy from old table...
  6. Answers
    1
    Views
    993

    Oracle Re: RAC Migration

    good one ..
  7. Answers
    3
    Views
    920

    Oracle Re: printing 'Odd' and 'Evan'

    order by clause orders the empno,according to that order rownum will assign to
    that row . if u dont want order by clause then remove that order.
    but there is a difference in output with order and...
  8. Answers
    3
    Views
    920

    Oracle Re: printing 'Odd' and 'Evan'

    Try this ...
    Select e.*, DECODE (Mod (ROWNUM, 2), 1, 'odd', 0, 'even') status
    From emp e
    Order By empno
  9. Answers
    2
    Views
    1,408

    SQL Re: reverse a string

    Try this.............

    Select Replace (Replace (str, ',', Null), '</t>', Null)
    From (Select Replace (XMLAGG (XMLELEMENT ("t", str)), '<t>', ',') str
    From (Select SUBSTR ('welcome',...
  10. SQL Server - Re: 1st and 2nd Maximum salary through same SQL Query

    Try this ..

    Select empno, ename, sal,
    DECODE (ROWNUM,
    1, ROWNUM || 'st Highest Salary',
    2, ROWNUM || 'nd Highest Salary'
    ) remark
    From...
  11. Answers
    1
    Views
    1,557

    Oracle Re: Get back Data From a Unused Column

    It is not possible to get back the unused column,because u can't issue set used counterpart for set unused command.
  12. Answers
    2
    Views
    1,346

    Oracle Re: Get field value with comma separated

    Check this one also
    Select deptno,
    Rtrim
    (Ltrim (Replace (Replace (XMLAGG (XMLELEMENT ("t", ename)),
    '<t>',
    ...
  13. Answers
    2
    Views
    1,346

    Oracle Re: Get field value with comma separated

    Just try this...

    Select deptno, SUBSTR (SYS_CONNECT_BY_PATH (ename, ','), 2) emp_name
    From (Select ename, deptno, Count (*) Over (Partition By deptno) cnt,
    ...
  14. Answers
    2,332
    Views
    185,849

    Re: Thoughts of the day.

    If u Desire to blossam like a rose in the garden ,u must have to learn the art of adjusting with the thorns....
  15. Thread: Date

    by susarlasireesha
    Answers
    5
    Views
    1,508

    SQL Re: Date

    u just pass date varibale in sql query ....

    select * from table
    where CL_DATE_TIME >=LAST_DAY(TO_DATE('15-jan-2010'))-TO_CHAR(LAST_DAY(TO_DATE('15-jan-2010'))-1,'DD')
    and CL_DATE_TIME<...
  16. SQL Re: How to compare previous row with current in SQL?

    i think no need to modify existing struncture

    Select *
    From (Select ROWNUM r1, col1, col2
    From dummy1) t1,
    (Select ROWNUM r2, col1, col2
    From dummy1) t2
    Where...
  17. Answers
    2
    Views
    928

    SQL Re: Global Area

    System global area (sga): allocated at instance startup, and is a fundamental component of an oracle instance program global area (pga): allocated when the server process is started
  18. SQL Re: How to get firstname,middlename & lastname from column

    @debasisdas check ur qry ,that will not work for all the cases ...

    Try this


    select substr (ename, 1, instr (ename, ' ', 1, 1)), substr (ename, instr (ename, ' ', 1, 1),
    instr (ename, ' ',...
  19. Answers
    2
    Views
    890

    SQL Re: Character Count in String

    Try this

    select length('database') - length(replace('database','a',null)) from dual
  20. Answers
    3
    Views
    1,126

    Oracle Re: how to get the data..........

    What is ur actual requirement ?? just u clear it ??
  21. Answers
    5
    Views
    9,625

    Oracle Re: To find Dependent Objects ....

    Hi suresh

    thanks for ur reply. what my actual requirement is

    how to find dependent objects with out using different table ??
  22. Answers
    2
    Views
    1,199

    Oracle Re: pl/sql table as a parameter

    Just try this way

    set serveroutput on

    create or replace procedure test_pltable is
    type emp_tab is table of scott.emp&#37;rowtype index by binary_integer;
    t_emp_tab emp_tab;
    procedure...
  23. Answers
    5
    Views
    9,625

    Oracle Re: To find Dependent Objects ....

    Thanks debasisdas

    But in (dba)user_dependencies , i will get only packages,procedures,function,views etc associated with table.but i want different keys,indexes ..etc assoctiated with that table...
  24. Answers
    5
    Views
    9,625

    Oracle To find Dependent Objects ....

    How to find how may objects are dependent up on a Table using sql qry ??
    including pk,fk,unique keys and related indexes
  25. Answers
    2,332
    Views
    185,849

    Re: Thoughts of the day.

    'Let's all be masters of our mouths, so that we won't be slaves of our words.'
Results 1 to 25 of 500
Page 1 of 20 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