Home » SQL & PL/SQL » SQL & PL/SQL » Using CLOB/BFILE to store payslips (Oracle 10g)
Using CLOB/BFILE to store payslips [message #409509] Mon, 22 June 2009 23:59 Go to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi,
I have to store payslips in database....in some folders that should get named as 10000 for first 10000 payslips and then another folder should get automatically created for 10001 to 10999 payslips in folder named 20000. The table is created as

CREATE TABLE PAYSLIP_MASTER
(
   PK_PSM_ID NUMBER(20,0)  NOT NULL,
   PK_PSM_NAME VARCHAR2(20)  NOT NULL,
   PSM_PAY CLOB,
   PSM_CREATE VARCHAR2(100),
   PSM_MODE VARCHAR2(100),
   PSM_CREDIT TIMESTAMP(6)
)


The data against the column PSM_PAY comes as a path like
D:\oracle\product\10.2.0\oradata\PAYPLUS\lobs\payplus_payslip_master\payplus_payslip_master.0
D:\oracle\product\10.2.0\oradata\PAYPLUS\lobs\payplus_payslip_master\payplus_payslip_master.1
D:\oracle\product\10.2.0\oradata\PAYPLUS\lobs\payplus_payslip_master\payplus_payslip_master.2


The filenames like 'payplus_payslip_master.2' in range from payplus_payslip_master.0 to payplus_payslip_master.10000 should be stored in a folder named 10000 and file ranging from 10001 to 20000 in folder named 20000 and so on....and should get happening like this when data grows....with creation of new folders....

I have basic knowhow of CLOB but here I am not sure how to go about the client requirement.

Please give me some insight if anyone has done something similar to this.

Regards,
Mahi
Re: Using CLOB/BFILE to store payslips [message #409931 is a reply to message #409509] Wed, 24 June 2009 09:06 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you store the payslips in CLOBS, then they won't live in folders in the OS at all - they'll be stored in the databae, in exactly the same way that any other column is.
Previous Topic: Select within a select?
Next Topic: Build logic
Goto Forum:
  


Current Time: Sat Dec 03 09:56:41 CST 2016

Total time taken to generate the page: 0.14294 seconds