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
Type: Posts; User: raghav_sy; Keyword(s):
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
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...
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...
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...
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...
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...
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...
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...
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.)
...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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....
hi,
Dual is very special table, one row and one column. well see it below:
SQL> desc dual;
Name Null? Type
------------------------------- -------- ----
DUMMY ...
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...