Why is that when I retrieve a date column with time format ('dd-mon-yyyy hh:mi:ss), I get the time for all the records as 12:00:00 ? How can is see the actual time in the date column?
Hi All, Getting the following error in Oracle9i on AIX, unique index ORA-01652: unable to extend temp segment by 128 in tablespace USERS; though the USER tablespace is of 10gb.Could anyone provide a solution.Regards,Ashish Thomas
Hi All, How do i run the otrcsvr.sql file in Oracle9i, it is suppose to be available in @$ORACLE_HOME/rdbms/admin; But its is not present in that folder. Can i use another script on Oracle 9i to achieve the same ?Regards,Ashish
Latest Answer: declareserch_item number;a number;b number;beginserch_item:=:emp.empno;b:=:system.cursor_record;first_record;a:=:system.cursor_record;for i in a..b-1 loopif srich_item=:emp.empno thenmessage('Employee No Already Exists')raise form_trigger_failre;elsenext_record;end ...
Latest Answer: Both commands are same but each is executed at different situations.When we directly want database should come in mount stage we give startup mount and when we want to do some modifications at nomount stage then first we nomount the database then give ...
Hi there - I am new to Oracle (used to Ingres).I am having trouble creating a database.I keep getting the following oracle errors.ORA-01501ORA-01519ORA-00604ORA-30012Can you tell me what I am doing incorrectly?Many thankseibbed
I have win xp having oracle 9.2 and on same system win 2k having oracle 9.0. can I share data , redolog and control file . if yes then how? please give example. as per me its just not possible.
Latest Answer: After update of the table, the view automatically gets synchronized where as the Materialised view needs an explicit refresh (either Manual or by Oracle) for synchronisation.Another diff is that the rowids of the table and view matches, whereas the MV's ...
Latest Answer: WHEN WE ARE UPDATING A TABLE AND AT THE SAME TIME TRYING TO RETRIEVE DATA FROM THAT TABLE. IT WILL RESULT INTO MUTTAING TABLE AND IT WILL RESULT INTO MUTATING ERROR.WE CAN RESOLVE IT BY DECLARING 'PRAGMA AUTONOMUS TRANSACTION' ...
View page << Previous 11 12 13 14 [15] 16 17 18 19 20 Next >>
Go Top
