Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Kalyan Ganesan

    Query not inserting both the columns into MS Access tables

    Yes Oracle 11 ,can i have the code for it?
  2. Kalyan Ganesan

    Query not inserting both the columns into MS Access tables

    Andrzejek Sorry i pasted the request to get the code to read from CSV into Oracle table in the wrong posting,but i am assuming you can help me on this,so i need the code to INSERT two columns data in a TABLE in Oracle from a CSV file, i need this done using code and not thru wizard or any...
  3. Kalyan Ganesan

    How to move a excel file into oracle

    Hi Bill, So now that you said Oracle is NOT capable of reading the data from an excel spreadsheet,can oracle read CSV file thru pl sql and insert two columns into a oracle table?i can do this manually(thru the import tool) i know that but all this needs to be run in a script in production that...
  4. Kalyan Ganesan

    Query not inserting both the columns into MS Access tables

    Can oracle read CSV file thru pl sql and insert two columns into a oracle table?i can do this manually i know that but all this needs to be run in a script in production that is why..
  5. Kalyan Ganesan

    How to move a excel file into oracle

    Hi Bill(Beilstwh) So lets say i get the grants done to access the excel file from the directory in Oracle What would be the code to insert the data from two columns in the excel file into the oracle table..I need the exact code without any external packages like ExcelTable and all that...
  6. Kalyan Ganesan

    How to move a excel file into oracle

    I too just now noticed that ExcelTable is some package we need to download to use it,i am surprised they dont have a way to see the files in a oracle directory in a straight forward way,like a function that would return all the file details you know..well the version of oracle i am using is...
  7. Kalyan Ganesan

    How to move a excel file into oracle

    select * from ALL_DIRECTORIES; shows only three directories and TNS_NAMES_DIR is NOT among them so that means i cant have access correct also what is the code to see all the files in a directory in oracle is UTL_FILE used for that too?
  8. Kalyan Ganesan

    How to move a excel file into oracle

    Because there is no read only access,even this query wouldnt work right? SELECT t.* FROM TABLE( ExcelTable.getRows( ExcelTable.getFile('TNS_NAMES_DIR','Test.xlsx') , 'Sheet_name_goes_here' , ' "Account_NBR" for ordinality , "Account Name" Number...
  9. Kalyan Ganesan

    How to move a excel file into oracle

    actually i moved the excel file into the folder TNS_NAMES_DIR thats the folder where the tnsnames files are stored, couldnt find the path for RCO but i just guessed that TNS path would be where the TNS Files are , but i get the permissions error when i try to access the file i created a stored...
  10. Kalyan Ganesan

    How to move a excel file into oracle

    So the file can be moved to the database server? How can that be done? For example i See a directory name as RCO and the directory path points to /download/rco So where is this directory and how can i move the excel file there so that i can read it thru PL SQl Code
  11. Kalyan Ganesan

    How to move a excel file into oracle

    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...
  12. Kalyan Ganesan

    Query not inserting both the columns into MS Access tables

    I tried this create table LOAN_LIST_Test as select * from LOAN_LIST_VLS; INSERT INTO LSDMGR.LOAN_LIST_Test(NEW_LOAN_NUMBER,OLD_LOAN_NUMBER) VALUES(7400760339,410011260339); select * from LOAN_LIST_Test; It showed that it has both the column values How could this work when the original table...
  13. Kalyan Ganesan

    Query not inserting both the columns into MS Access tables

    Actually i did try that and it wouldn't let me insert values that way ....this is very strange.like i said there are no triggers on the linked table in Oracle,no contraints,no primary key,but the allow null is checked as Yes,but thats for both columns,dont know why it would prevent only this one...
  14. Kalyan Ganesan

    Query not inserting both the columns into MS Access tables

    new loan number is just null,it just doesnt insert into it ,there are no constraints or conditions so yes null must be allowed
  15. Kalyan Ganesan

    Query not inserting both the columns into MS Access tables

    Tried INSERT INTO LOAN_LIST ( NEW_LOAN_NUMBER, OLD_LOAN_NUMBER ) VALUES (123, 678) inserts 678 into old_loan_number
  16. Kalyan Ganesan

    Query not inserting both the columns into MS Access tables

    In Loan_List Table the two columns are number, sheet1 table both the columns are numbers,also i didnt see any constraints or dependencies in the table Loan_list
  17. Kalyan Ganesan

    Query not inserting both the columns into MS Access tables

    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...
  18. Kalyan Ganesan

    Updating recordset property in runtime form becomes non editable

    Yes thats the query but i have a different module in the same project which uses a similar query but that fetches way more data this query above fetches like 500 rows but the idea is the same
  19. Kalyan Ganesan

    Updating recordset property in runtime form becomes non editable

    Yes when i open the subform as a datasheet alone i am able to edit the records,did i answer your question,and the recordsource for that is a query that is set in property sheet and the query has two tables joined
  20. Kalyan Ganesan

    Updating recordset property in runtime form becomes non editable

    Its a complex query this one..it joins two tables,is that why?

Part and Inventory Search

Back
Top