Recent content by rawatds

I think i got it : I can Select all Group where any Ids are having expiry_date not equal to 23-DEC-2010 and then use this as a Subquery select * from table where group_id not in ( SubQuery )

Hi All, I have a requirement where i need to provide a SQL statement to front application. The data is like Login_id Login_group Expiry_date 100 1 23-DEC-2010 101 1 23-DEC-2010 102 1...

Hi, My requirement is that i have to get the MAX or Greatest of the three values from three tables and replace each value with the Hightest value. Example : select age2 = c.age - b.age, age3 = a.age - b.age, age1 = a.age from a , b , c where a.name = b.name and a.deptid = c.deptid Now my...

Hi Santa, The records in the table LIST_HOME and LIST_COPY are inserted as a DISTINCT value from some other tables. So is there any worth to create index on these tables. Thanks DR

Hi Gurus, I Have the following query which i want to tune. Select a.add, a.stamp_updt, b.cur_typ_c from record_master a, Detail_record b where a.id = p_id and a.unit_id in (select unit_id from list_home) and a.unit_c in (select unit_c from list_copy) and a.id_c = b.id_c Where...

Hi As per my understanding the whole concept of package is that it loaded itself in the memory when any procedure which is defined in the package is called. is there any method which i can do or oracle itself loaded only that procedure in the memory rather then whole package which is called...

Hi all, I have a query where i have to use a Self join on a table i want to avoid it as it is taking time. My data is : Table 1 Column1 column2 column3 x y z A B C Table 2 Column1 Column2 Column3 column4 1 2...

Hi Mufasa Thanx a lot a ran the three above mentioned query and now my job run successfully Once again a lot rawat

Hi Mufasa I run the freespace.sql in my database . The following is the result : SYSTEM 1 83,886,080 83,886,080 83,412,992 473,088 NO '/u01/oradata/vsis/system01.dbf' SYSTEM 81 52,428,800...

Hi all When i run a job in my database , following error is coming : ORA-01654: unable to extend index SYS.I_COL3 by 50 in tablespace SYSTEM . I donot have much knowledge on this regard . Can anybody please help me out what i have to do to correct it. Thanx in advance rawat

Hi my requirement is : 1. Create a list of server names in a file 2. User would chose from the above list (to be displayed as a menu) and do the tasks as per server selected from the menu. 3. Switch-case should be flexible i.e if we delete or add any server name onto the above list it...

Hi all Is menu driven by SELECT can be a dynamic ? My requirement is that i want SELECT to be created on run time not predefine . The select should be created as per the no of words in a file thanks in advance rawat

Hi All I want a method in shell script which will embed the exe file into rtf file si that the rtf file can be open in word and so my exe. Actually what is happening in my system at present : The report in my system is a self-extracting Zip file with filetype '.EXE'. Double clicking on...

Hi everybody My requirement is : The shell script should be able to : 1. Create a list of server names in a file 2. User would chose from the above list (to be displayed as a menu) and do the tasks as per server selected from the menu. 3. Switch-case should be flexible i.e if we delete or...

Hi I search in the man goodpw but in my /usr/lib i couldnot find goodpw file also in passwd file in /etc/default i could get only for minimun character i.e. PASSLENGTH=6 but not for other constraints . Any help Regards rawat