to_single_byte(c1)

最新推荐文章于 2024-03-19 01:18:10 发布

原创最新推荐文章于 2024-03-19 01:18:10 发布 · 4.7k 阅读

3 ·

CC 4.0 BY-SA版权

个人随笔，有用你就COPY

oracle_函数专栏收录该内容

63 篇文章

订阅专栏

本文介绍了一个实用的字符串转换函数to_single_byte(),该函数能够将输入的全角字符转化为对应的半角字符,适用于文本规范化处理场景。

to_single_byte(c1)
【功能】将字符串中的全角转化为半角
【参数】c1,字符型
【返回】字符串

【示例】

SQL> select to_multi_byte('高Ａ') text from dual; test ---- 高A

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

HelloBoat

关注关注

0
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

Oracle函数大全一百零九：TO_SINGLE_BYTE函数

yixiaobing的博客

06-05

1197

名称功能：将字符串中的多字节字符转换为等价的单字节字符。函数是Oracle中用于将多字节字符转换为等价的单字节字符的函数。它在处理包含中日韩等字符集的数据库时特别有用。在使用该函数时，需要注意字符集和排序规则的设置，并了解不是所有多字节字符都有对应的单字节字符。

SystemC自带example的simple_bus研习

chenleiyfk的博客

07-09

1255

simple_bus是一个简单的总线模型的抽象描述，基于时钟同步的事务级建模。时钟同步：这种时钟节拍精度的仿真会导致仿真速度变慢。目标是在一个时钟一个时钟的基础上对系统中的组织和数据移动进行建模，并与等效的真实系统进行比较，会忽略节拍内的事件。事务建模：各功能组件之间的通信被描述为函数调用，一组总线的事件或事件序列由抽象的软件接口以及相应的函数调用表示。接口的事务级建模比基于pin的建模具有更高的仿真速度，同时也加快了建模构建过程。 ...

参与评论您还未登录，请先登录后发表或查看评论

Oracle内建函数(greatest, least, to_single_byte)

matt8的专栏

05-03

1680

取一个一维数组中的最大值greatestSELECT Greatest(a,x,fit,xa) FROM dual;取一个一维数组中的最小值leastSELECT Least(a,x,fit,xa,ab) FROM dual;全角的数字/字母/标点符号转半角to_single_byteSELECT To_Single_Byte(２１，５００

内置函数to_single_byte

ckae8456的博客

09-06

3423

在很多软件系统中，并没有对非法输入进行处理；将半角数值输入为全角数值的情况很常见。在存储的时候，一个半角数字占1个byte，但是一个全角数字需要占3个byte 因为全角的原因，原本定义的字段长度很不容易出现长度...

to_single_byte

iteye_7017的博客

05-27

1308

在很多软件系统中，并没有对非法输入进行处理；将半角数值输入为全角数值的情况很常见(本来应该只能输入半角数值，但是你输入全角字符了)。在存储的时候，一个半角数字占1个byte，但是一个全角数字需要占3个byte 因为全角的原因，原本定义的字段长度很容易出现长度不够的情况可以使用oralce的内置函数to_single_byte来转换一下，使用这个函数会将全角字符转换为半角的字符，对于半角的...

如何进一步将 decode_single_block_0 使用 SIMD 或 Java Vector API 加速？

11-05

// expand to int IntVector g = ... // 更复杂，需跨字节合并 IntVector b = srcHigh.and(0b11111000).castShape(...); IntVector argb = NEG_ONE.or(r.mul(65536)).or(g.mul(256)).or(b); argb.intoArray(dstBuf...

import idaapi import idc import idautils import ida_nalt def analyze_elf_structure(): """Analyze ELF file structure in detail""" print(f"\n{'='*60}") print("ELF Structure Analysis") print(f"{'='*60}") # Get ELF header info inf = idaapi.get_inf_structure() print(f"Processor: {inf.procname}") print(f"File Type: {ida_nalt.get_file_type_name()}") print(f"Image Base: 0x{inf.base:016X}") # List all segments with detailed info print(f"\n{'='*60}") print("Segment Mapping (VA ↔ File Offset)") print(f"{'='*60}") print(f"{'Name':<12} {'Start VA':<16} {'End VA':<16} {'File Off':<12} {'Size':<12}") print(f"{'-'*70}") for n in range(idaapi.get_segm_qty()): seg = idaapi.getnseg(n) if seg: seg_name = idaapi.get_segm_name(seg) start_va = seg.start_ea end_va = seg.end_ea size = end_va - start_va # Try to get file offset file_off = idaapi.get_fileregion_offset(start_va) if file_off == -1: file_off_str = "N/A" else: file_off_str = f"0x{file_off:X}" print(f"{seg_name:<12} 0x{start_va:<14X} 0x{end_va:<14X} {file_off_str:<12} 0x{size:<10X}") def calculate_file_offset_detailed(va_address): """ Calculate file offset with detailed explanation """ print(f"\n{'='*60}") print(f"Detailed File Offset Calculation") print(f"{'='*60}") # Get segment containing the address seg = idaapi.getseg(va_address) if not seg: print(f"❌ Address 0x{va_address:X} not in any segment!") return None seg_name = idaapi.get_segm_name(seg) seg_start = seg.start_ea # Get file offset directly if available file_offset = idaapi.get_fileregion_offset(va_address) print(f"Target VA: 0x{va_address:X}") print(f"In segment: {seg_name}") print(f"Segment start VA: 0x{seg_start:X}") print(f"Offset in segment: 0x{va_address - seg_start:X}") if file_offset != -1: print(f"\n✅ Direct file offset mapping found!") print(f"File offset: 0x{file_offset:X}") # Show the relationship if file_offset == va_address: print(f"\n📌 Special case: File offset equals VA") print(f" This means .text starts at file offset 0x{seg_start:X}") else: print(f"\n📌 Relationship: VA 0x{va_address:X} → File 0x{file_offset:X}") print(f" Delta: 0x{va_address - file_offset:X}") else: # Try to calculate based on common patterns print(f"\n⚠️ No direct file offset mapping") print(f"Trying to calculate based on ELF patterns...") # Common ARM64 patterns if seg_name == ".text": # Pattern 1: .text at 0x28000 in file calc1 = (va_address - seg_start) + 0x28000 # Pattern 2: .text at 0x1000 in file calc2 = (va_address - seg_start) + 0x1000 # Pattern 3: Direct mapping (your case) calc3 = va_address print(f"\nPossible calculations:") print(f" 1. If .text @ file 0x28000: 0x{calc1:X}") print(f" 2. If .text @ file 0x1000: 0x{calc2:X}") print(f" 3. If direct VA=File mapping: 0x{calc3:X}") # Ask user which one to use print(f"\nSelect calculation method:") print(f" [1] Pattern 1 (0x28000 offset)") print(f" [2] Pattern 2 (0x1000 offset)") print(f" [3] Direct mapping") print(f" [4] Custom offset") choice = input("Choice (1-4): ").strip() if choice == "1": file_offset = calc1 elif choice == "2": file_offset = calc2 elif choice == "3": file_offset = calc3 elif choice == "4": custom = input("Enter custom .text file offset (hex): ").strip() try: custom_offset = int(custom, 16) file_offset = (va_address - seg_start) + custom_offset except: print("Invalid offset!") return None else: print("Invalid choice!") return None return file_offset def extract_hex_bytes(va_address, num_bytes=16): """Extract hex bytes from memory""" hex_bytes = [] for i in range(num_bytes): byte = idaapi.get_byte(va_address + i) hex_bytes.append(byte) # Format for MemoryPatch hex_str = " ".join([f"{b:02X}" for b in hex_bytes]) # Also create C array format c_array = ", ".join([f"0x{b:02X}" for b in hex_bytes]) return hex_str, c_array, hex_bytes def generate_patches(va_address, file_offset, hex_str): """Generate different patch formats""" print(f"\n{'='*60}") print("Patch Code Generation") print(f"{'='*60}") # Format 1: MemoryPatch (Android) print(f"\n📱 MemoryPatch (Android):") print(f"{'-'*40}") patch_code = f'MemoryPatch::createWithHex("libanogs.so", 0x{file_offset:X}, "{hex_str}").Modify();' print(patch_code) # Format 2: Direct hex patch print(f"\n🔧 Direct Hex Patch:") print(f"{'-'*40}") print(f"Offset: 0x{file_offset:X}") print(f"Bytes: {hex_str}") # Format 3: Binary patch command print(f"\n💻 Binary Patch Command (xxd):") print(f"{'-'*40}") print(f"printf '{hex_str.replace(' ', '')}' | xxd -r -p | dd of=libanogs.so bs=1 seek=$((0x{file_offset:X})) conv=notrunc") # Format 4: C code for inline patching print(f"\n👨‍💻 C Inline Patching Code:") print(f"{'-'*40}") bytes_list = hex_str.split() c_code = f"""uintptr_t patch_addr = base_address + 0x{va_address:X}; // Or use dlopen+dlsym unsigned char patch_bytes[] = {{{', '.join([f'0x{b}' for b in bytes_list])}}}; memcpy((void*)patch_addr, patch_bytes, sizeof(patch_bytes));""" print(c_code) def interactive_analyzer(): """Interactive analyzer with options""" print(f"\n{'='*60}") print("IDA ELF File Offset Analyzer") print("="*60) while True: print(f"\nOptions:") print(f" 1. Analyze current address") print(f" 2. Enter address manually") print(f" 3. View ELF structure") print(f" 4. Generate patch from current") print(f" 5. Exit") choice = input("\nSelect option: ").strip() if choice == "1": # Current address current_ea = idc.get_screen_ea() if current_ea != idaapi.BADADDR: print(f"\n📍 Current address: 0x{current_ea:X}") analyze_single_address(current_ea) else: print("❌ No valid address at cursor!") elif choice == "2": # Manual address addr_str = input("\nEnter VA (hex): ").strip() try: if addr_str.startswith("0x"): va_address = int(addr_str, 16) else: va_address = int(addr_str, 16) analyze_single_address(va_address) except: print("❌ Invalid address!") elif choice == "3": # ELF structure analyze_elf_structure() elif choice == "4": # Generate patch from current current_ea = idc.get_screen_ea() if current_ea != idaapi.BADADDR: generate_patch_from_address(current_ea) else: print("❌ No valid address at cursor!") elif choice == "5": break else: print("❌ Invalid option!") def analyze_single_address(va_address): """Analyze a single address""" print(f"\n{'='*60}") print(f"Analyzing 0x{va_address:X}") print(f"{'='*60}") # Get disassembly disasm = idc.generate_disasm_line(va_address, 0) print(f"Instruction: {disasm}") # Get function info func = idaapi.get_func(va_address) if func: func_name = idaapi.get_func_name(func.start_ea) print(f"Function: {func_name} (0x{func.start_ea:X}-0x{func.end_ea:X})") # Calculate file offset file_offset = calculate_file_offset_detailed(va_address) if not file_offset: return # Extract hex bytes hex_str, c_array, raw_bytes = extract_hex_bytes(va_address, 16) print(f"\n🔍 Hex Bytes (16 bytes):") print(f" {hex_str}") print(f"\n📊 C Array:") print(f" {{{c_array}}}") # Generate patches generate_patches(va_address, file_offset, hex_str) # Ask to copy to clipboard copy = input(f"\n📋 Copy MemoryPatch code to clipboard? (y/n): ").strip().lower() if copy == 'y': try: import pyperclip patch_code = f'MemoryPatch::createWithHex("libanogs.so", 0x{file_offset:X}, "{hex_str}").Modify();' pyperclip.copy(patch_code) print("✅ Copied to clipboard!") except: print("⚠️ Install pyperclip: pip install pyperclip") def generate_patch_from_address(va_address): """Quick patch generation from address""" file_offset = calculate_file_offset_detailed(va_address) if not file_offset: return hex_str, _, _ = extract_hex_bytes(va_address, 16) print(f"\n✅ Quick Patch Code:") print(f"{'='*40}") print(f'MemoryPatch::createWithHex("libanogs.so", 0x{file_offset:X}, "{hex_str}").Modify();') print(f"{'='*40}") def show_simple_dialog(): """Simple dialog for quick analysis""" import ida_kernwin # Get current address current_ea = idc.get_screen_ea() # Ask for address or use current if current_ea != idaapi.BADADDR: default_addr = f"0x{current_ea:X}" else: default_addr = "0x228654" addr_str = ida_kernwin.ask_str(default_addr, 0, "Enter virtual address (hex):") if not addr_str: return try: if addr_str.startswith("0x"): va_address = int(addr_str, 16) else: va_address = int(addr_str, 16) # Quick analysis file_offset = calculate_file_offset_detailed(va_address) if file_offset: hex_str, _, _ = extract_hex_bytes(va_address, 16) # Show result result = f"""Analysis Complete! Address: 0x{va_address:X} File Offset: 0x{file_offset:X} Hex Bytes: {hex_str} MemoryPatch Code: MemoryPatch::createWithHex("libanogs.so", 0x{file_offset:X}, "{hex_str}").Modify();""" # Display in message box ida_kernwin.msg(result) # Also print to console print(f"\n{result}") except ValueError as e: ida_kernwin.warning(f"Invalid address: {e}") # Run the script if __name__ == "__main__": # Choose your preferred mode: # Mode 1: Simple dialog (recommended for beginners) show_simple_dialog() # Mode 2: Full interactive analyzer # interactive_analyzer() # Mode 3: Quick analysis of current address # current_ea = idc.get_screen_ea() # if current_ea != idaapi.BADADDR: # analyze_single_address(current_ea) Address: 0x228560 File Offset: 0x228560 Hex Bytes: FF 43 01 D1 FD 7B 03 A9 F4 4F 04 A9 FD C3 00 91 MemoryPatch Code: MemoryPatch::createWithHex("libanogs.so", 0x228560, "FF 43 01 D1 FD 7B 03 A9 F4 4F 04 A9 FD C3 00 91").Modify(); this is result getting from script MemoryPatch::createWithHex( "libanogs.so", 0x28654, "E0 03 C0 FF E1 83 C1 B2 E2 07 C2 B2 E3 0B C3 B2" ).Modify(); this result find by ai why both diffrent

12-06

"E0 03 C0 FF E1 83 C1 B2 ..." ).Modify(); ``` 说明它认为某个指令位于： - 文件偏移：`0x28654` - 对应内存地址：`0x228654`（很可能是光标所在位置）再反推 `.text` 段参数： ```text VA: 0x228654 File ...

最新发布

12-06

| `0x228654` | `E0 03 C0 FF E1 83 C1 B2 ...` | 这是两个不同的地址，当然机器码不同！ --- ## ✅ 总结解释 - 你的脚本错误地认为 **虚拟地址 = 文件偏移**。 - 实际上必须通过 ELF 的 Program Header 映射： ...

11-07

用户提供的代码是GC05A2传感器的MIPI驱动程序，其中已经包含了一些OTP（One-Time Programmable）相关的函数，比如gc05a2_otp_init、gc05a2_otp_close、gc05a2_otp_read_single等。看起来这些函数可能已经用于读取...

Byte4ToSingle.rar

04-27

VB调用C的dll库实例，4字节转为1个实数,用于通讯数值转换

【GBase 8a MPP数据库集群】TO_SINGLE_BYTE

zxnkiss87的博客

09-27

1118

to_single_byte：全角转半角的函数名;arg: to_single_byte 函数的参数，可以为任何类型的值和列。如果 arg 为字符串，并且字符串里面含有全角的话，在输出结果中就会将全角字符转为半角字符，其他字符保持不变。该函数仅在 UTF8 字符集和 GBK 字符集下有效。create as select 时候，函数的 field_type 根据 result_type 来确定，见。

通过Oracle识别字符串中的中文or字母or数字来介绍全角半角转换函数(to_multi_byte/to_single_byte)在varchar/clob中的使用案例