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                             Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM

Categories  >>  Software  >>  Databases  >>  SQL PLSQL        Suggest New Category      Question  Asked @ Answers Views     select   What is the different between Stored Procedure and Procedure? Informatica   0  31 How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra  1  38 how to saw triggers output in pl/sql database?  1  448 HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.  8  510 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? Oracle  3  716 When the mutating error will comes? and how it will be resolved?  2  305 Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?  2  254 what is Complex index. how to create it?  1  119 how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance  3  268 hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?  1  151 how to connect oracle in unix prompt? Polaris  2  379 Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy Target  4  313 Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Target  2  176 what the meaning of sql  5  468 what is oracle sql,pl/sql with interfaces TCS  1  277 E-Mail New Answers        Answer Selected Questions      [1]    2  ... 3   ... 5   ... 7   ... 9   ... 11   ... 13   ... 15   ... 17   ... 19   ... 21   ... 23   ... 25   ... 27    Next         Oracle Interview Questions     SQL Server Interview Questions     MS Access Interview Questions     MySQL Interview Questions     Postgre Interview Questions     Sybase Interview Questions     DB Architecture Interview Questions     DB Administration Interview Questions     DB Development Interview Questions     SQL PLSQL Interview Questions     Databases AllOther Interview Questions       Un-Answered Questions    Question Views Asked at   Select   what is indexing, searching and user interface? 41 HCL what is the boundary line in varrays? 50   what are the demerits of sql? 180   what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details? 47   Which one is the Best approach to put code, among Triggers and Procedures? Explain? 106 Sierra-Atlantica what is organisational index? 77   when MSQL8.0 is in market 58   What are code pages ? 56 BirlaSoft oracle is compiler or interpretter,can any one tell me the answer? 1071   What action do you have to perform before retrieving data from the next result set of a stored procedure ? 102 Microsoft GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error? 63 Virtusa What is the different between Stored Procedure and Procedure? 31 Informatica Authentication mechanisms in Sql Server ? 62 BirlaSoft write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/ 397 iFlex What are the attributes of SQL*PLUS ? 40 Oracle How well can multiple sessions access the same data simultaneously ? 44   after tell procedure whole code he asked can i write the same way in a function 60   what is the bond code in materialized view? 71   Does it possible to pass object (or) table as an argument to a remote procedure? 363 TCS If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000???? 63   E-Mail New Answers        Answer Selected Questions

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