Advertise your Business Here      Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new    Refer this Site               Login  |  Sign Up                             Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE

Company Name Starts with ... #  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z   Search Company Name ::      Company >> Oracle >> Interview Questions >> SQL PLSQL Interview Questions     Oracle Errors Interview Questions (3)   J2SE Code Interview Questions (1)   C Code Interview Questions (1)   Australia Visa Interview Questions (1)   Oracle Certifications Interview Questions (1)   Puzzles Interview Questions (1)   General Aptitude Interview Questions (1)   APPSC AllOther Interview Questions (1)   Accounting AllOther Interview Questions (3)   Accounting General Interview Questions (1)   Non Technical Interview Questions (3)   Human Resources Interview Questions (1)   Finance Interview Questions (1)   Marketing Sales Interview Questions (5)   Engineering AllOther Interview Questions (2)   Electronics Communications Interview Questions (1)   Mechanical Engineering Interview Questions (1)   Oracle Service Contracts Interview Questions (1)   Oracle Apps SCM Interview Questions (2)   Oracle Apps CRM Interview Questions (1)   Oracle Apps HRMS Interview Questions (9)   Oracle Apps Manufacturing Interview Questions (3)   Oracle Apps Financial Interview Questions (48)   Oracle Apps Technical Interview Questions (26)   ERP General Interview Questions (2)   Siebel Interview Questions (3)   PeopleSoft Administration Interview Questions (1)   SRM Interview Questions (1)   FI CO Interview Questions (2)   Basis Interview Questions (1)   UML Interview Questions (1)   HR Questions Interview Questions (1)   Data Warehouse General Interview Questions (3)   SAS Interview Questions (32)   Data Stage Interview Questions (1)   Informatica Interview Questions (4)   Cognos Interview Questions (1)   Business Objects Interview Questions (5)   Weblogic Interview Questions (3)   J2EE Interview Questions (1)   Struts Interview Questions (1)   Advanced Java Interview Questions (2)   Core Java Interview Questions (14)   COBOL Interview Questions (1)   Testing AllOther Interview Questions (5)   QA Concepts Interview Questions (13)   Manual Testing Interview Questions (23)   Automation Testing AllOther Interview Questions (1)   Test Director Interview Questions (1)   QTP Interview Questions (14)   Load Runner Interview Questions (1)   Operating Systems General Concepts Interview Questions (1)   Solaris General Interview Questions (2)   Unix AllOther Interview Questions (1)   Unix Commands Interview Questions (1)   Linux AllOther Interview Questions (4)   Linux General Interview Questions (2)   Linux Commands Interview Questions (6)   SQL PLSQL Interview Questions (25)   DB Administration Interview Questions (3)   SQL Server Interview Questions (9)   Oracle AllOther Interview Questions (10)   Forms Reports Interview Questions (4)   Database Management Interview Questions (2)   Architecture Interview Questions (1)   Oracle General Interview Questions (37)   Networking Administration Interview Questions (1)   VB Script Interview Questions (1)   CGI Perl Interview Questions (1)   PHP Interview Questions (2)   Programming Languages AllOther Interview Questions (2)   C++ General Interview Questions (1)   OOPS Interview Questions (1)   C Interview Questions (15)     Question   also Asked @ Answers Views     select   i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON Hcl  2  424 trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.    1  264 i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.    1  208 what is the difference difference between procedure and packages  2  883 wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod? Tecnics TCS  4  2021 what are pl/sql collections?  4  6503 How can i insert data inro a table with 3 columns using FORALL?    2  4554 What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet? Not In Company But Generally For Knowledge  9  5519 how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c    8  3803 why use cursors?    5  4164 i want to display 1 to 10 numbers using one select statement. Nyros  16  9301 Differences between UNIQUE and DISTINCT in select statements Dellote Hewitt Dell Abs  25  56563 Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ? Diff Betwn Nested Table And Varray Differents Between Nested Table And Varray In Differents Between Nested Table And Varray In  6  4755 How do you optimize SQL queries ? Carrizalsoft Technologies  6  8333 Two Methods of retrieving SQL? Atiric Tcs Wipro Financial Services  6  25467 E-Mail New Answers        Answer Selected Questions        Post New Oracle Interview Questions SQL PLSQL    [1]   2    Next

Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |            Copyright © 2012  ALLInterview.com.  All Rights Reserved. ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com