how do we code triggers , store procedure , Performance
tuning
and indexing in a Java Project? Pls kindly get me the
perfect answer with the code for each....thank you in
advance............pls any body kindly help me soon as
possible....
No Answer is Posted For this Question
Be the First to Post Answer
Display the records between two range?
How to create a table index?
Give syntax for SQL and ORACLE joins.
What are the commands youd issue to show the explain plan for select
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
What happens if you lost a data file?
What is self-referential integrity constraint ?
How to retrieve values from data fields in record variables?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
What is SAVE POINT ?
Why do we need oracle client?