Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Generate a Sequence like in Oracle Post 302177200 by jim mcnamara on Thursday 20th of March 2008 09:43:00 AM
Old 03-20-2008
You have to have persistent storage - a file, a database table, etc. Oracle sequences are stored along with other metadata like the schema on disk.

Try using a file. But. If this is for multiple processes with simultaneous access, then you have to use some sort of resource locking mechanism - a file lock might be an option. See either man flock or maybe man ioctl
 

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Generate report in HTML file from Oracle DB

Hi Team, I need a suggestion/comments for my below requirement. I have a procedure which performs some DDL operations & loads data into a Oracle table. This status contains Audit data. What i wanted to do is, once the procedure is completed (daily), shell script should retrive the data from the... (4 Replies)
Discussion started by: Amit.Sagpariya
4 Replies

2. Shell Programming and Scripting

generate a sequence

how can i generate following sequence for a given input 1,2,3,4,5 1->2 2->3 3->4 4->5 1->2,3 1,2->3 2->3,4 2,3->4 3->4,5 3,4->5 1->2,3,4 1,2->3,4 1,2,3->4 (4 Replies)
Discussion started by: vaibhavkorde
4 Replies

3. Shell Programming and Scripting

find common entries and match the number with long sequence and cut that sequence in output

Hi all, I have a file like this ID 3BP5L_HUMAN Reviewed; 393 AA. AC Q7L8J4; Q96FI5; Q9BQH8; Q9C0E3; DT 05-FEB-2008, integrated into UniProtKB/Swiss-Prot. DT 05-JUL-2004, sequence version 1. DT 05-SEP-2012, entry version 71. FT COILED 59 140 ... (1 Reply)
Discussion started by: manigrover
1 Replies

4. Shell Programming and Scripting

Script to generate sequence of numbers

I need awk script to generate part number sequencing based on data in multiple columns like below Input File --------- Col A|Col B|Col C| 1|a|x| 2|b|y| |c|z| | |m| | |n| And out put should be like 1ax 1ay 1az 1am 1an 1bx 1by (6 Replies)
Discussion started by: aramacha
6 Replies

5. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

6. BSD

Mcookie, pkg -l to generate random sequence

I am setting this thread to this bsd forum, though it may fit into bash. But as using bsd and the terminal, I would like to generate a random sequence of alphanumerical digits, such as I use to do so on linux by typing just mcookiethis one gives me a pretty random password, but it does not on bsd... (0 Replies)
Discussion started by: 1in10
0 Replies

7. Shell Programming and Scripting

Parameterizing to dynamically generate the extract file from Oracle table using Shell Script

I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by modifying the script and show me how to execute it. First Requirement: I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies
FLOCK(3)								 1								  FLOCK(3)

flock - Portable advisory file locking

SYNOPSIS
bool flock (resource $handle, int $operation, [int &$wouldblock]) DESCRIPTION
flock(3) allows you to perform a simple reader/writer model which can be used on virtually every platform (including most Unix derivatives and even Windows). On versions of PHP before 5.3.2, the lock is released also by fclose(3) (which is also called automatically when script finished). PHP supports a portable way of locking complete files in an advisory way (which means all accessing programs have to use the same way of locking or it will not work). By default, this function will block until the requested lock is acquired; this may be controlled with the LOCK_NB option documented below. PARAMETERS
o $handle -A file system pointer resource that is typically created using fopen(3). o $operation -$operation is one of the following: o LOCK_SH to acquire a shared lock (reader). o LOCK_EX to acquire an exclusive lock (writer). o LOCK_UN to release a lock (shared or exclusive). It is also possible to add LOCK_NB as a bitmask to one of the above operations if you don't want flock(3) to block while locking. o $wouldblock - The optional third argument is set to 1 if the lock would block (EWOULDBLOCK errno condition). RETURN VALUES
Returns TRUE on success or FALSE on failure. CHANGELOG
+--------------+---------------------------------------------------+ | Version | | | | | | | Description | | | | +--------------+---------------------------------------------------+ |5.5.22, 5.6.6 | | | | | | | Added support for the $wouldblock parameter on | | | Windows. | | | | | 5.3.2 | | | | | | | The automatic unlocking when the file's resource | | | handle is closed was removed. Unlocking now | | | always has to be done manually. | | | | +--------------+---------------------------------------------------+ EXAMPLES
Example #1 flock(3) example <?php $fp = fopen("/tmp/lock.txt", "r+"); if (flock($fp, LOCK_EX)) { // acquire an exclusive lock ftruncate($fp, 0); // truncate file fwrite($fp, "Write something here "); fflush($fp); // flush output before releasing the lock flock($fp, LOCK_UN); // release the lock } else { echo "Couldn't get the lock!"; } fclose($fp); ?> Example #2 flock(3) using the LOCK_NB option <?php $fp = fopen('/tmp/lock.txt', 'r+'); /* Activate the LOCK_NB option on an LOCK_EX operation */ if(!flock($fp, LOCK_EX | LOCK_NB)) { echo 'Unable to obtain lock'; exit(-1); } /* ... */ fclose($fp); ?> NOTES
Note flock(3) uses mandatory locking instead of advisory locking on Windows. Mandatory locking is also supported on Linux and System V based operating systems via the usual mechanism supported by the fcntl() system call: that is, if the file in question has the set- gid permission bit set and the group execution bit cleared. On Linux, the file system will also need to be mounted with the mand option for this to work. Note Because flock(3) requires a file pointer, you may have to use a special lock file to protect access to a file that you intend to truncate by opening it in write mode (with a "w" or "w+" argument to fopen(3)). Note May only be used on file pointers returned by fopen(3) for local files, or file pointers pointing to userspace streams that imple- ment the streamWrapper.stream_lock(3) method. Warning Assigning another value to $handle argument in subsequent code will release the lock. Warning On some operating systems flock(3) is implemented at the process level. When using a multithreaded server API like ISAPI you may not be able to rely on flock(3) to protect files against other PHP scripts running in parallel threads of the same server instance! flock(3) is not supported on antiquated filesystems like FAT and its derivates and will therefore always return FALSE under this environments (this is especially true for Windows 98 users). PHP Documentation Group FLOCK(3)
All times are GMT -4. The time now is 01:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy