vasuv

Hi All, I am working on Oracle 11.2.0.3. and my requirement is, I have a table in Development(Dev) called " Dev_EMP". Have created Synosym for "Dev_EMP" as "SY_DEV_EMP" here is the structure [/code] create table Local_emp ( tran_id varchar2(10), acct_id varchar2(15) ); [/code] 2. Table which I am planning to …

Hi, I am currently working on Oracle 11.2.0.3. Below is my requirement. 1.I would like to scan the database ( Eg. 1 entire schema) and need to find the DB object either Procedure/Funcation which is having DROP statement. ( some of the procedures having " DROP PROCEDURE <PROCEDURE_NAME> " statements. …

Hi all, I am planning to design mibile app using c,c++ if possible.can any one please suggest me how to design it if possible. Please your thoughts regarding this and appreciate your suggestions. Thanks, Va.

Hi, I would like to build a mobile appliations to find out the locations of the hospitals lists all over the state ( distrcit wise) in my mobile. Could you please suggest How can I develop mobile app for the above requirement. Thanks, Vas.

Hi All, Could you Please give me your valuable suggestions for the following requirement. I am not sure whether this is the right place to post this thread but please have a look and give me your suggestions. 1. I am planning to design a ticket tracking tool. 2. If …

Hi All, We are planning to write automation script to install oracle. Can you please let us know is it possiblw to write any script for the above requirement,if yes please share your thoughts. Thanks, Vas.

Hi, Some jobs got scheduled.let us take an example of 5 jobs. first 4 jobs got scheduled in one server(assume it as A).last jobs got scheduled in another server(assume it as B).so the requirement here is once the 4 jobs got completed in server A, then we need to connect …

Hi, I am new to HTML kind of stuff. I have some documents in my own folders for different applications. I want keep all the documents in related Hyperlink under that particular department. after creating all the hypertlinks that link link should navigate to that particular document. once it is …

Hi, we have some scheduled jobs.The jobs will truncate the data and inserting the data and update the data.This process will happen daily. we receive files like truncate_file,Insert_file and update_file to our INBOX in scheduled time.once we got the update_file we will connect to front end application by using user_id …

Hi, we have some scheduled jobs.The jobs will truncate the data and inserting the data and update the data.This process will happen daily. we receive files like truncate_file,Insert_file and update_file to our INBOX in scheduled time.once we got the update_file we will connect to front end application by using user_id …

Hi All, We are using one application. This application is having 2types of jobs. Under each job again there are each 5 sub jobs. All the jobs are scheduled jobs. Now the requirement is The main 2 jobs we are going to run on some specified days( for this we …

Hi, I am not aware where to post my query.That's why here I am posting my query.I am sorry for my mistake. Here the requirement is s to write small JYTHON script to modify some parameters on a WebSphere cluster at install time. I am new to this concept. SO …

Hi, we are having some scheduled jobs.If these jobs runs successfully the files will be arrived into the some specified folder.But some times I am unable to find out the files are not yet arrived. So now i want to write an automation script which will inform you like the …

Hi All, i have basic python knowledge please let me know how to get started with jython please let me know where can i find good online books for jython, how to write some small programs and how to run them

Hi All, I want to write an automation script, which will send log files of Scheduled jobs via email for every one hour. Please help me out to write a script for this. Thanks.

Hi All, Please find the following requirement and let me know the possibilities if any. We have some daily,weekly and monthly jobs which will run parallelly.we need to monitor the jobs.there we have start time ,we need to find out the end time and need to paste it in excel …

Hi , I have a excel sheet.in that one column called hardcoded. we have sheet as folllows. Name EMp_ID Hardcoded ---------------------------- ABC 1987870 1. EMP_SAL_CD : "2000","1300","Avg100" 2. DEPT_CD : "Manager","clerk","anlyst" 3. DNAME : "SALES","HR" STU 1909890 1.EMP_SAL_CD : "6000","300","A100" 2. DEPT_CD : "Manr","cle","ant" 3. DNAME : "SALES","HR","STUD" --- --- …

Hi, we have pl/sql objects.for some pl/sql objects we found the object names in the scheduler list to run it.But we didn't found the some objects to run the jobs. the scheduler contains Object list. if you select one object and click on submit button then it will show u …

Hi, I have one Oracle standalone procedure.In this am doing truncating the data and loading the new data into the target table. The issue is , I want to know whether the table is callable from other procedure,if it it callable I want to know the Procedure or Packages list. …

Hi all, We have many number of Procedures/Packages/Functions/Package bodys.In these objects some coulmns contains Hardcoded values.we need to find out the hardcoded values for that particular column.Right now we are doing manually by analyzing the code and find out the hardcoded values. Is it possible to write any shell script …

Hi All, This is Vasu.I am new to this software field.Now I started learning Unix n Oracle. Daily we are doing the following job manually.But I am planning to automate it.So any one please help me to write a script for the following requirement.It's very helpful to learn new things. …