Today I tried something new.. How to add a combo box to an excel, whose values come from some range in the sheet. So here you go..
I am using EXCEL 2002. Go to the menu.. View >> Toolbars >> FormsDrag and drop the combo box on the sheet. Rt click the combo box and select "Format Control" property and in the "Input Range" select the range where the values which you want to appear on the combo box exits. This can be a region on the same sheet or on a different sheet. Here I have selected the first row of Sheet2 "Sheet2!$A$1:$A$34"
Click the combobox and you can see the values are populated!
Thursday, November 05, 2009
Thursday, October 29, 2009
ORACLE query which returns all table names which contains a particular field.
The following ORACLE query returns all table names which contains the column 'EMPLOYEE_ID'.
SELECT * FROM ALL_TAB_COLUMNS C, ALL_OBJECTS O
WHERE C.TABLE_NAME = O.OBJECT_NAME
AND C.OWNER = O.OWNER
AND O.OBJECT_TYPE = 'TABLE'
AND COLUMN_NAME LIKE 'EMPLOYEE_ID'
AND C.OWNER = 'YOUR_SCHEMA_NAME '
AND TABLE_NAME NOT LIKE 'BIN%'
PS: Replace YOUR_SCHEMA_NAME with the name of your DB schema.
SELECT * FROM ALL_TAB_COLUMNS C, ALL_OBJECTS O
WHERE C.TABLE_NAME = O.OBJECT_NAME
AND C.OWNER = O.OWNER
AND O.OBJECT_TYPE = 'TABLE'
AND COLUMN_NAME LIKE 'EMPLOYEE_ID'
AND C.OWNER = 'YOUR_SCHEMA_NAME
AND TABLE_NAME NOT LIKE 'BIN%'
PS: Replace YOUR_SCHEMA_NAME
Subscribe to:
Posts (Atom)