Interested to Buy Any Domain ? << Click Here >> for more details...
Given a SQL Statement, if you have been asked to check the
right syntax ?
- 1 Answers
- 5254 Views
- I also Faced
- E-Mail Answers
Answer / nimmathota
Run in backend whether WinSQL or Toad and check if errors
out if it is the cursor will stop exactly where the syntax
is wrong
| Is This Answer Correct ? | 0 Yes | 1 No |
What hyperlinks available in PeopleBooks?
Where would you install connectivity software?
DB is in windows, application server can be configured in Windows or Unix or Anyone?
What bea product is used for db transaction in peoplesoft?
What is peoplesoft server process logs?
Tell us about web servers.
Where do you need to install connectivity software?
Explain what are the search keys you use to find patches and fixes?
How can you launch configuration manager?
one particular query taking long time how to reduce that time
Your Onsite DBA has called you up and told you that one of the tables PS_ABC_TAO has grown very big in size. Based on the standard naming convention, you have determined that the record is a temporary record since it ends with _TAOYou look into the database and decide that that the data is not required any more. You ask the DBA to delete the data in the table.Next day you get a call from an irritated user who says that a daily process that took only 1 minute to run is taking about 2 hours today. You look into his process and find that it uses PS_ABC_TAO as a temporary table.What would you suggest the DBA to do ?
Which process is used for running AE programs which are to be run at a frequency of less than a day ?
PeopleSoft HRMS 
