Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Answers
    10
    Views
    11,299

    Re: help handling error with trigger

    well even if use set feeback off, the message will not be displayed, but the row will be inserted. which actually should not happen.lets wait for some one to sort out this problem

    Regards,
    RSY
  2. Answers
    10
    Views
    11,299

    Re: help handling error with trigger

    hi,

    thanks dear for posting such a good question, really its rare to see good questions.

    well, the real answer for this problem is that, error stack is always
    returned, there is no way to...
  3. SQL Re: Details of emp having the 788th highest salary

    hi,

    the query for this is:

    table name is : EMP

    select * from emp X where &N = (select count(distinct(salary)) from emp Y where Y.salary >= X.salary);

    here it will ask for the value of N...
  4. Answers
    4
    Views
    17,060

    Oracle Re: Date Function in Oracle

    Hi, there are lot of date functions available. That much of time is not there to explain everything, so i am pasting here some material, which i prepared when i entered to this software field, may be...
  5. Answers
    3
    Views
    4,356

    Oracle Re: Coding with PL/SQL

    hi,

    coding standard is like a bible for any company, so we have to follow it.

    and u can not follow your own coding standard or any coding standard mentioned in books. these standard differ...
  6. Re: please respond

    hi,

    well this thing depends upon at which level u are joining company.

    if u are joining as fresher then no need to take any tension. lot of time will be there to get used to process, and mostly...
  7. Answers
    8
    Views
    5,427

    Re: testing

    hi friend,

    well i do not agree with amarreddy. till now i have not seen any product delivered to cleint without testing. testing will always be done.

    well there are lot of limitations on...
  8. Answers
    54
    Views
    1,081,562

    Windows Re: How to enable/disable USB ports

    hi friend,

    try this:

    ok, on the desktop, right click on MY COMPUTER, and then select MANAGE option. a new window will appear, in that select SYSTEM TOOLS, in that click on DEVICE MANAGER, on...
  9. Re: Priority, severioty

    hi,

    i will try to put in simple words:

    Severity: Its the impact or importance of bug with respect to application. (i.e. how much that bug will be hampering the application process.)
    ...
  10. Answers
    4
    Views
    4,239

    Oracle Re: Errors after compilation

    hi,

    Bhuvana, click on the thanks button if u want to say thanks, that will add to my reputation. :D

    ok, and one more thing, if u are using the suggestion which i gave, in real time, then...
  11. Answers
    4
    Views
    46,079

    Oracle Re: Default username/password for Oracle 8i

    hi,

    we always use Scott/tiger. but let me add one intresting point to this:

    Scott: was the first employee of Oracle corp.
    Tiger: was the name of his cat.

    hope u will enjoy this...
  12. Thread: about sql

    by raghav_sy
    Answers
    36
    Views
    76,475

    SQL Server - Re: about sql

    hi good morning friends,

    Indexes are optional structures associated with tables used to speed query execution. an index is created if there is frequent retrieval of fewer than 10-15% of the rows...
  13. Re: B.E. 55% aggerigate - Scope of Software Testing

    hi friend,

    well u are in pune, and thats a good thing. make a try there. and one more thing u have to attach exp., its very difficult to manage without that. that is the harsh truth.

    best...
  14. Thread: about sql

    by raghav_sy
    Answers
    36
    Views
    76,475

    SQL Server - Re: about sql

    hi,

    hey good thing to know kalayama. i read that MSDN link. and u are correct for sql server alter...modify is not used.

    now aarusa will search for us.
    sorry aarusa. i gave u the suggestion...
  15. Thread: about sql

    by raghav_sy
    Answers
    36
    Views
    76,475

    SQL Server - Re: about sql

    hi,

    sorry i went to have lunch.

    well, the version will not have any effect.

    and yes, Kalayama the query 'alter table c alter column name not null' will not work on Oracle, i am not sure...
  16. Thread: about sql

    by raghav_sy
    Answers
    36
    Views
    76,475

    SQL Server - Re: about sql

    hi friend,

    what ever u did is working on my system, i do not know what has happened to it on your system. well i executed the same thing on my system, and see the result below:

    SQL> create...
  17. Thread: about sql

    by raghav_sy
    Answers
    36
    Views
    76,475

    SQL Server - Re: about sql

    hi friend,

    i do not know why u are getting the error, i did a lot of experiment but not able to get your error. for me all the queries are working.

    its very difficult to understand where u have...
  18. Thread: about sql

    by raghav_sy
    Answers
    36
    Views
    76,475

    SQL Server - Re: about sql

    hi,

    the data type will not have any affect on query, both will work.

    the only problem is that, in the query table name is missing. and even after using table name, the query is failing then...
  19. Thread: about sql

    by raghav_sy
    Answers
    36
    Views
    76,475

    SQL Server - Re: about sql

    hi friend,

    that is not the case, the null values in columns, create problem depending upon the type of constraint we are going to create.

    if u are creating unique or check constraint on the...
  20. Thread: about sql

    by raghav_sy
    Answers
    36
    Views
    76,475

    SQL Server - Re: about sql

    hi friend,

    do not pay attention to that 2 in the query i wrote, actually i run that command on sql plus and copied from there, so that 2 is the line number. so neglect that 2.

    i think some data...
  21. Thread: about sql

    by raghav_sy
    Answers
    36
    Views
    76,475

    SQL Server - Re: about sql

    hi,

    well i will give the example:

    SQL> create table d1( id number(10),
    2 name varchar2(20));

    this will create table d1 with columns id and name without any constraint. now for adding...
  22. Answers
    2
    Views
    6,585

    Oracle Re: Which RDBMS follows all CODD rules

    hi,

    well oracle satisfy 11 rules out of 12. it fails in rule 6, that is view updation.
    in oracle its not possible to update complex views.( has been overcome using instead of trigger).

    so u...
  23. Answers
    12
    Views
    5,140

    General Re: flashback table

    hi friends,

    well a lot of things have been discussed on flash back, but i want to add one more thing, this feature is present in oracle 9i also.
    check out for DBMS_FLASHBACK package in oracle 9i....
  24. Thread: Dual Table

    by raghav_sy
    Answers
    7
    Views
    5,062

    SQL Re: Dual Table

    hi,
    Dual is very special table, one row and one column. well see it below:

    SQL> desc dual;
    Name Null? Type
    ------------------------------- -------- ----
    DUMMY ...
  25. Answers
    6
    Views
    7,957

    SQL Re: Finding Error in PL/SQL Code

    hi friend,

    honestly i do not have any idea abt PRO* C, but yes SQLERRM will work in pl/sql.

    well u can hae a look here:

    sql> create table d (sl number(3), name varchar2(2));

    SQL> set...
Results 1 to 25 of 31
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