Databases Interview Questions
Questions Answers Views Company eMail

how to i write the query 'NISHI' TO N I S H I

Attra, Metric Stream,

4 3833

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 1364

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

TCS,

1 1447




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

TCS,

2 1874

difference between SQL and C

Indus Software Technologies,

1 1600

Why fastload support to empty table?

CTS,

636

Teradata: How can we know the indexed column in a table?

CTS, HSBC,

720

how to overcome kernel isssues

Fortune,

544

how to restore particular schema from rman full backup?

HCL,

738

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?

HCL,

1 1189

what is logical system in sap basis

464

how to solve cardinality in dbms...many to many ralationships

707

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

Access Info,

463

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

Alshaya,

1 1270

How to display all Friday's in a year with date?

Flipkart,

3 2828







Un-Answered Questions { Databases }

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

730


last function used in MS Access to convert sql what function will use in sql

940


1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

764


Give two methods you could use to determine what DDL changes have been made.

4808


Can you tell me how to add new column in existing views?how?How is possible?

251






can u give guidance abt packages of plsql

900


What are code pages ?

1077


How can set the multipal database ?

1808


In which table collections errors are stored.

1205


What is the recommended interval at which to run statspack snapshots, and why?

1684


How to do Data integrity testing? Who does this testing (Developer or tester)?

973


how can you attach more than 20 ldf files in sql server

916


what is ora 24313?what is the procedure to exclude that error?

1378


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

1199


WHAT KIND OF TOOL BO IS?

1208