Oracle CHM help file Download _oracle

[Q] How to query special characters, such as wildcard% and _
[Q] How to insert single quotes into a database table
[Q] How to set transactional consistency
[Q] How to use the cursor to update data
[Q] How to customize exceptions
[Q] decimal and hexadecimal conversions
[Q] Can you introduce the detailed usage of Sys_context
[Q] How to get today is the day of the week, also about other date function usage
[Q] The problem of randomly extracting the first N records
[Q] Extract records from n rows to m rows, such as records from 20 to 30 rows
[Q] How to extract duplicate records
[Q] How to set up autonomous transactions
[Q] How to pause a specified time in a procedure
[Q] How to calculate the transaction time and log quantity quickly
[Q] How to create a temporary table
[Q] How to execute DDL statements in Pl/sql
[Q] How to get the IP address
[Q] How to encrypt stored procedures
[Q] How to run a stored procedure periodically in Oracle
[Q] How to get milliseconds from the database
[Q] If there is an update, there is no insert can be implemented with a statement
[Q] How to achieve leftist, right and outer union
[Q] How to implement a record inserts according to the Condition multiple table
[Q] How to implement row and column conversions
[Q] How to implement the group to take the first N records
[Q] How to merge adjacent records into a single record
[Q] How do I get the nth value in a column?
[Q] How to output the query content to the text
[Q] How to set caller permissions for a stored procedure
[Q] How do I execute OS commands in a sql*plus environment?
[Q] How to quickly get the number of records per table or table partition under the user
[Q] How to send an email in Oracle
[Q] How to write operating system files in Oracle, such as writing a log
Download Address