Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Get the number of rows affected by a truncate

Neo-bApr 9 2012 — edited Apr 9 2012
Hello All,

I want to get the number of rows affected by truncate commands without selecting the count from the table. is there any way?

for delete, insert and updated i used sql%rowcount; before the commit, is there something like for truncate?

Regards,

Comments

clcarter

There is no support for XE, see http://www.oracle.com/technetwork/licenses/database-11g-express-license-459621.html section No Technical Support

A 12c (or 13?) XE will be available when its available, not a day sooner.

Mike Kutz
Answer 
clcarter wrote:
There is no support for XE, see http://www.oracle.com/technetwork/licenses/database-11g-express-license-459621.html section No Technical Support
A 12c (or 13?) XE will be available when its available, not a day sooner.

Oracle changed their numbering convention to_char('RR.Q')  --- year dot quarter

18c XE was announced at last year's Oracle Open World.  18c would be equivalent to 12.2.0.2

There will still be no technical support for XE.  (you get what you pay for)

MK

Marked as Answer by 863710 · Sep 27 2020
1 person found this helpful
863710

Hi Mike,

Thanks for your valuable feedback.

This means we can use Oracle 18c XE latest version instead of 11g XE. I have heard that it is for cloud please correct me if i am wrong.

Also let me know the date of EOL (End- Of- Life) or their is no EOL because their is no support?

BR,

Naveed

863710

One more thing is their any licensing cost for XE? I assume that their is no licensing cost since their is no technical support available.

Tércio Costa

No, there´s no cost to use, even with commercial apps.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 7 2012
Added on Apr 9 2012
2 comments
1,677 views