ALLInterview.com :: Home Page
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
 Categories >> Software >> Databases
 
  Oracle (1963)   SQL Server (1097)   MS Access (27)   MySQL (200)   Postgre (50)
  Sybase (22)   DB Architecture (8)   DB Administration (215)   DB Development (56)   SQL PLSQL (827)
  Databases AllOther (114)
 
Suggest New Category 
 


 

Question Asked @ Answers Views     Select
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.    0  13
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??    0  15
how to solve cardinality in dbms...many to many ralationships    0  17
what is logical system in sap basis    0  11
user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?    0  34
how to restore particular schema from rman full backup?    0  23
how to overcome kernel isssues    0  20
Teradata: How can we know the indexed column in a table?    0  24
Why fastload support to empty table?    0  17
difference between SQL and C    1  34
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6    2  101
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL    1  65
Hi Guys, I have a situation where I need to access the column values from rowtype variable. However, the column names are dynamic. below is sample code: declare Cursor c1 is select * from emp; Cursor c2 is select column_name from xyztable; v_c2 c2%rowtype; v_str varchar2 v_value varchar2(200); begin for rec in c1 loop open c2;---this cursor has column names like EMPLOYEE_ID, FIRST_NAME, LAST_NAME etc. loop fetch c2 into v_c2; exit when c2%notfound; /* now lets say i want to access value of LAST_NAME from cursor c1, so I am writing below code, however it does not work as expected */ v_str:= 'rec.'|| v_c2.column_name; -- this will give me string like "rec.EMPLOYEE_ID" v_value:=v_str; end loop; end loop; end; / Plz help ASAP.Thanks.    2  88
how to i write the query 'NISHI' TO N I S H I    4  476
difference between bind variable and variable    1  96
E-Mail New Answers        Answer Selected Questions       
 [1]    2  ... 22   ... 43   ... 64   ... 85   ... 106   ... 127   ... 148   ... 169   ... 190   ... 211   ... 232   ... 253   ... 274   ... 295    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
why dont we assign not null constraint as table level constraint. 956
If the job running very slow what is the action you do 333
how can you attach more than 20 ldf files in sql server 539
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ? 2883
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that? 447
What are the built-in functions used for sending Parameters to forms ? 1675
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???? 2333
i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE 1330
Can any one send me oracle form and reports tutorials from which i may get help.contact me on my mail cse_kashif@hotmail.com. 657
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm. 549
How can you move the master database 493
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance 559
How internally data stores in MyISAM and INNODB table types? 935
By using Macromedia Director How to fetch the data from Microsoft Excel? 904
what is the difference between filters and conditions? 768
E-Mail New Answers        Answer Selected Questions