|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ora-06504 PL/SQL: Return types of Result Set variables or query do not match By: v4goel on Thu, 25 October 2007 |
11 |
16806 |
Thu, 01 December 2016 12:39 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Function MAX Oracle 11g By: tomekw on Thu, 01 December 2016 |
3 |
2026 |
Thu, 01 December 2016 10:08 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to search for two characters in any sequence, with or without alphanumeric characters in between Oracle 11g, 12c |
13 |
3033 |
Tue, 29 November 2016 15:36 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Star printing in PL/SQL Program Problem 11g |
13 |
14180 |
Tue, 29 November 2016 14:06 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to pass date parameters in dynamic sql? PL sql By: nukala on Mon, 28 November 2016 |
8 |
11717 |
Tue, 29 November 2016 07:38 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Function returns Record - How to select |
8 |
3130 |
Sat, 26 November 2016 06:44 By: vactirio ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to generate a insert script as it is what ever we running the insert script? insert into dept(deptno,dname,loc) values (70,'PERSONNEL','DALLAS') |
9 |
4167 |
Sat, 26 November 2016 04:40 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
using rownum oracle 10 g |
14 |
4366 |
Fri, 25 November 2016 07:06 By: Bill B ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Trigger to prevent update/delete/insert operation |
4 |
2636 |
Fri, 25 November 2016 03:18 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Trigger to prevent delete according to select 11.0.2.10 |
9 |
4979 |
Thu, 24 November 2016 08:16 By: ALEXWE ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Please provide best approach to design ETL in Oracle. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production By: msol25 on Thu, 24 November 2016 |
4 |
1659 |
Thu, 24 November 2016 07:20 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL Query Update 11g By: glmjoy on Thu, 24 November 2016 |
4 |
1821 |
Thu, 24 November 2016 06:11 By: msol25 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
complex query oracle By: bikashp on Wed, 23 November 2016 |
1 |
1683 |
Wed, 23 November 2016 06:35 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
electronic data sharding |
14 |
4476 |
Tue, 22 November 2016 07:26 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Update Table Based On Another Table oracle 11g, windows server By: morissa on Fri, 18 November 2016 |
14 |
10190 |
Tue, 22 November 2016 03:38 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Show all months between 2 months in a group by query Oracle 11g By: avni on Mon, 21 November 2016 |
1 |
2231 |
Mon, 21 November 2016 03:09 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Rows not populating Oracle DB 12c |
9 |
2380 |
Fri, 18 November 2016 14:18 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle 11g Ntile function on top of Dense_rank |
1 |
2036 |
Wed, 16 November 2016 23:36 By: raj85844 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to close open cursor when exception oracle 11 By: yk107 on Tue, 15 November 2016 |
11 |
5212 |
Wed, 16 November 2016 12:57 By: yk107 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Calling procedure from trigger Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit Windows 7 By: SW26477 on Wed, 16 November 2016 |
2 |
1739 |
Wed, 16 November 2016 10:32 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
merge statement problem 10g |
15 |
5533 |
Mon, 14 November 2016 07:56 By: emadnabil ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Filling a table of object in function loop 11.0.2.10 |
7 |
3189 |
Mon, 14 November 2016 06:31 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Need to match combination string at database Oracle 11g, AIX server |
12 |
14196 |
Mon, 14 November 2016 00:21 By: Shan.kumar ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
PL/SQL Email Oracle 11gr2 |
3 |
2254 |
Sat, 12 November 2016 06:48 By: VariableReset ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL Query Request oracle 11g |
14 |
5323 |
Fri, 11 November 2016 10:19 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
spool sql data in excel multi sheets |
3 |
2145 |
Fri, 11 November 2016 04:17 By: pablolee ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to log what parameter the API is passing to query oracle 11g By: magnify on Wed, 09 November 2016 |
3 |
1688 |
Wed, 09 November 2016 12:22 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Search data between months Oracle 11g By: Xandot on Wed, 09 November 2016 |
2 |
1753 |
Wed, 09 November 2016 05:07 By: Xandot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Getting months in the current Fiscal Year in Oracle Oracle Database 11g Enterprise Edition |
5 |
2505 |
Wed, 09 November 2016 03:01 By: Flyby ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query help Oracle |
14 |
13725 |
Tue, 08 November 2016 10:36 By: Solomon Yakobson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
external table with single column oracle 11g |
23 |
7679 |
Tue, 08 November 2016 07:06 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Procedure execution issue and trace 11g r2, linux |
7 |
2543 |
Tue, 08 November 2016 03:56 By: cookiemonster ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
conversion to 16bit decimal oracle 11gr2 |
16 |
6175 |
Mon, 07 November 2016 10:09 By: guddu_12 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Conditional based default value Oracle 11 |
5 |
2736 |
Mon, 07 November 2016 08:05 By: saipradyumn ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
package modified details oracle 12c, unix |
6 |
2078 |
Sun, 06 November 2016 02:27 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
query needed without using only where clause 10g |
3 |
1757 |
Sat, 05 November 2016 02:00 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Selecting the columns Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production |
32 |
10762 |
Fri, 04 November 2016 11:24 By: Solomon Yakobson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
summation of multiple values for a particular at specific period oracle 10.g |
10 |
3406 |
Fri, 04 November 2016 11:04 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query Help Oracle 11g |
14 |
5388 |
Fri, 04 November 2016 04:03 By: SADASIVAM ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to format JSON column RDBMS 12C |
5 |
3268 |
Thu, 03 November 2016 09:04 By: samiraly ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |