Search results for query: *

I am familiar with the DBA_DIRECTORIES and ALL_DIRECTORIES But i want to know how to move a excel file into Oracle Directory Like when i run this query select * from dba_directories SYS ORACLE_OCM_CONFIG_DIR2 /oracle/app/oracle/product/11.2.0.4/db_risk/ccr/state SYS DV_ADMIN_DIR...

I have imported a table into MS Access from Excel.its called Sheet1 I have a query below INSERT INTO LOAN_LIST ( NEW_LOAN_NUMBER,OLD_LOAN_NUMBER ) SELECT TOP 100 Sheet1.[ACCT_NBR] AS NEW_LOAN_NUMBER,Sheet1.[V_Acct_Nbr] as OLD_LOAN_NUMBER FROM Sheet1; for some reason it doesnt insert the...

The recordset type i have is Dynaset (Inconsistent Updates) I am updating the recordset in runtime thru below code Dim strSelect As String Dim rs1 As DAO.Recordset strSelect = "SELECT * FROM MAIN" Set rs1 = CurrentDb.OpenRecordset(strSelect) Set Me![subform].Recordset = rs1 Set rs1 =...

I have this code in the Afterupdate and Afterchange events of a Combobox If Me![pageMain].LinkChildFields <> "GOLD_NUMBER" Then Dim strMasFld, strChlFld As String strMasFld = "cmbGoldNumb" strChlFld = "GOLD_NUMBER" Me![pageMain].LinkMasterFields =...

I have a main form and a subform, the main form has a combo box that will have a list of items patient no, once i choose one of those the sub form gets populated with data, the subform has a recorsource already set during design in the property sheet,but the challenge is i need to use one of the...

I want a code like this to work BEGIN ALTER TRIGGER SCEHEMA.TEST_UPDATE_TRG DISABLE; EXCEPTION WHEN OTHERS THEN WHEN OTHERS THEN err_num := SQLCODE; err_msg := SUBSTR (SQLERRM, 1, 100); err_loc := 'TEST_UPDATE_TRG'; err_date :=...

When i use DoCmd.TransferSpreadsheet to export, it assings a default folder and it allows me only to give the file name,how do i assign the folder name as well?

Can anyone tell me what all i need to create a procedure to export data to Excel...i tried using ORA_EXCEL but its giving me error When i try something like this below PROCEDURE' BEGIN ORA_EXCEL.new_document; ORA_EXCEL.add_sheet('My Sheet'); ORA_EXCEL.add_row...

I try to update data in a linked table thru MS Access and i get the Write conflict error This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changed to the clipboard will let you look...

I created a table using CREATE TABLE RETREIVERS AS SELECT * FROM DBL_RETREIVERS I created a linked table in MS Access that is pointing to this table, i am unable to enter any data in MS Access Linked Table,there are no constraints or triggers on this table in Oracle..why is it...

I have a accdb, everything in it was working fine,it has linked tables that are linked to Oracle (11g) and configured thru odbc,after the long weekend the system was restarted and i keep getting this error since yday runtime error 3151 when i open a form that connects to the database thru...

There are two tables in MS Access that are identical,they are linked tables,but the structure is same even though their database is different,so i tried INSERT INTO TableA SELECT * FROM TableB but it inserts three columns and two columns data is not inserted and left blank,but it doesnt give...

What to do for this error?

I have a insert statement in a query in MS ACCESS, the query runs and fetches the data fine but if i use a INSERT INTO TABLE and append it with the query with a select it gives the following error INSERT INTO statement contains following unknown field name I have done inserts on other queries...

I have a form in which all the controls are bound by the Recordsource of the form, when the form loads it bring sup all the 100 records from the two tables that are used to link the queries as the recordsource, all the controls are being non editable, so i gave the following but it doesnt do...

In a form I gave the option Vertical Only for Scroll bars but its not showing up, I tried resizing the form in runtime to see if it will show,it still doesn't show, is there any other property I need to set for it to show?Thanks

I copied a form(which is used as a subform in another form) along with all the controls and everything, the RecordSource of the form is also coming along as expected,but the problem is the form that i made a copy needs to have a different recordsource,so when i change the recordsource it...