Given a SQL Statement, if you have been asked to check the right syntax ?

Given a SQL Statement, if you have been asked to check the
right syntax ?

Question Posted / guest

Given a SQL Statement, if you have been asked to check the right syntax ?..

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

More PeopleSoft Administration Interview Questions

Which events get fired after db update?

What are the uses of psstatus table?

We can specifically trace the activity of the psappsrv server process by setting which one?

How to get a single ouptut by combining two or more queries?

You want to authenticate a user in peoplesoft. How would you do that?

I have created a Menu and a Page and given user access to that page, which of the tables gets affected on this?

What commands are valid in BS mode?

SYSAUDIT finds for?

What are the common elements in peoplesoft configuration manager?

Peoplesoft supports which web servers?

one particular query taking long time how to reduce that time

What is a connectivity software? Where would you install it?

For more PeopleSoft Administration Interview Questions Click Here