Question : Hi can you help me to split the name into firstname, middle name, lastname using a pl/sql procedure. […]
Tag: plsql
How to find object name given in a problematic query [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Difficulty Understanding Oracle DQL Procedures and Functions Coming from T-SQL
Question : I am much more familiar with SQL Server, but I am doing a project now in Oracle. There […]
PL/SQL : query numeric data type by scale?
Question : Wish to select rows with number fields having a certain amount of data after the decimal eg select […]
Can I exchange partition between two table with partition with same name?
Question : I am trying to restore one partition from a backup table. Both tables have partitions with the same […]
read/write/execute to pl/sql grants [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Compare two big tables in PL/SQL
Question : I need to implement comparing 2 tables by set of keys (columns of compared tables). By this comparing […]
What Oracle SQL syntax do I need to find transactions that occurred during time intervals of a day for a period of a year?
Question : I am looking at a transactional-level table for which I need to extract all transactions which occurred between […]
After Inserting , Update / Insert into another table in pl/sql trigger
Question : I am working on PL/SQL trigger i have two table TAG Table SR.NO ID TAG BRAND_ID —— —- […]
Improve performance for my plsql block
Question : First of all let me make kind of a disclaimer here: 1) i’m a developer, not an administrator; […]