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
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:
Cursor c1 is select * from emp;
Cursor c2 is select column_name from xyztable;
for rec in c1
open c2;---this cursor has column names like EMPLOYEE_ID, FIRST_NAME, LAST_NAME etc.
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"
Plz help ASAP.Thanks.
table name :Tab
3.account code (7 char)
4.account type (1 char)
Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit .
write a query to display the account code wise total debit and credit bal for the month of april 2004.
write a query to display account code wise new amt credit for the april 2004
From the database level, how can you tell under which time
zone a database is operating?
Assuming today is Monday, how would you use the DBMS_JOB
package to schedule the execution of a given procedure owned
by SCOTT to start Wednesday at 9AM and to run subsequently
every other day at 2AM.
I have some query regarding Report generation from Oracle
Apps "PO module".
I have to generate a report where table columns are as below:
Vendor_name Invoice No PO Number Item_Quantity Value of
Goods Date of Shipping Name_of_the_transport
Now my questions is :from which table/column I can get the
information of "Name_of_the_transport" column.
Thanks in advance.
Can you have a nested transaction?
what are questions asked in TCS for database tester
(sqlserver)for 2-3 exp?
In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
Which is better Oracle or MS SQL? Why?
Other than making use of the statspack utility, what would
you check when you are monitoring or running a health check
on an Oracle 8i or 9i database?
1)for snapshot replication which agents used?
2)for Transcation replication which agents used?
3)for merge replciation which agents used?
CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL
CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN
How to do performance tunning a database in DB2 V8.2 UDB
If a parameter is used in a query without being previously
defined, what diff. exist betw. report 2.0 and 2.5 when the
query is applied ?
why the Ctl file u put only in bin folder why not in other
IN oracle apps HRMS, if the employee changes his department,
and when a conconurrent program is run for calulating the
pay, The latest Dept id is not diaplayed, howeber the
previous deptid is considered. Please can someone tell me
where is the program going wrong, which side?
which background process invoke at the time of upgradation tell me???