I have a file on a Unix box that I need to read into my PL/SQL procedure. The file is 2904 bytes of data which it transpires is a contiguous string of 726 numbers of 4 bytes, so probably BINARY_FLOAT format, no line returns or new lines etc. I am struggling come up with the best way to read this data into my procedure, I eventually want to split it into 6 tables/collections each of 121 numbers. Any views or thoughts would be appreciated.
PL/SQL getting binary_float data from a file
173 Views Asked by Jaffa6 At
1
There are 1 best solutions below
Related Questions in PLSQL
- PLSQL Need REFCURSOR DATE + TIME
- PL SQL After Delete Trigger Not Inserting Record
- Oracle stored procedure wrapping compile error with inline comments
- How to compare multiple columns under same row in a table?
- How to find out which procedures and functions are using a table?
- How to display image in oracle form
- Oracle 11g : staging table
- 04098. "trigger '%s.%s' is invalid and failed re-validation"
- PL/SQL Check if SYSDATE is between two DATETIMES "HH24:mi"
- UTL_file: continue reading even if it encounters blank rows
- add time (char(8)) to date column
- if x not in(select y from table) in oracle
- Generate random ROWID
- Get same day of the same week last year
- Call procedure using anonymous block in pl/sql?
Related Questions in BINARY-DATA
- How to send raw data using socket.io
- Read binary file which has different datatypes
- Writing binary data to private ofstream produces unexpected result
- PL/SQL getting binary_float data from a file
- Compare and Identify the location and value at particular position and print it
- How do I convert Python Imaging Library code to PHP?
- Faster way for decimal to binary conversion
- How to play binary data (video file) on Web browser which is received from RestAPI
- Protobuf binary<->JSON serialization option / alternatives?
- PHP/PostgreSQL: writing binary data with prepared statements
- What's the best way to consume the bytes of NSData?
- Matlab : Binary to decimal conversion using symbols from clustering algorithm
- Reading binary data in python (to replace C code)
- Concatenate binary strings obtained from decimal to binary conversion
- How should I parse mysqldump binary output
Related Questions in FILE-READ
- Reset index of File object for reading several time
- PL/SQL getting binary_float data from a file
- How to use getline in spark from hdfs?
- How to read data from file till I encounter an empty line
- How to split a file in spring batch based on no of lines?
- Read/Write Strings and Images in a single file
- Stack around the variable 'st' was corupted
- How to create an activity that reads document files?
- Android - PieChart from text file
- Reading Numbers from a .dat file with numbers arranged columnwise into an array in C
- Count specific words from text file - Java
- extract from stringstream into 2D vector
- Read file until specific line in python
- How to store array in local file in ios?
- nodejs asynchronously reading continuously growing file
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Use utl_file library, with it you can do many operations on files.