Oracle Blogs

       FBDI (File Based Data Import) To import objects, you use a spreadsheet template (CSV) to enter the data you want to import, and then run the appropriate import process from the  Scheduled Processes  page. This blog shows the process to create suppliers using FBDI. to create supplier using fbdi we need  XLSM template which can be found by googleing 'FBDI suppliers' or click here  LINK FOR SUPPLIER FBDI click on link highlited to download the template. Open the template and fill all the mandatory fields After filling click on generate csv file button Save the zip file and csv file Now open fusion instance , Navigate to TOOLS > SCHEDULE PROCESSESS Search for "Load Interface File for Import" under import processess "Import Suppliers" and in data file click on upload new file and upload your zip file                           Now after submittting you can find your uploaded supp...

Example : select SUM(empno) OVER(PARTITION BY deptno) sum,emp.* from emp partition by is used to use group funtions without using group by clause and retrive all rows while grouping them. The   PARTITION BY clause sets the range of records that will be used for each "GROUP" within the  OVER  clause. In your example SQL,  DEPT_COUNT  will return the number of employees within that department for every employee record. (It is as if you're de-nomalising the  emp  table; you still return every record in the  emp  table.) emp_no dept_no DEPT_COUNT 1 10 3 2 10 3 3 10 3 < - three because there are three "dept_no = 10" records 4 20 2 5 20 2 < - two because there are two "dept_no = 20" records If there was another column (e.g.,  state ) then you could count how many departments in that State. It is like getting the results of a  GROUP BY  ( SUM ...