A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
JDBC and Relational Databases
Limit record in table
Joined: Sep 23, 2004
Sep 23, 2004 09:14:00
Hi, I'm trying to limit the number of record in an Oracle table. Is there any way to specify it when I create the table or I have to use trigger to verify if the limit is reached?
Thanks for your comments and suggestions.
author & internet detective
Joined: May 26, 2003
Sep 23, 2004 17:35:00
Yes, you need a trigger for that.
Welcome to JavaRanch!
OCA 8 book
How To Ask Questions The Smart Way
SCEA Part 1
Part 2 & 3
Core Spring 3
TOGAF part 1
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Limit record in table
Database Circular Reference
using JDBC how to move a record from one table to another within specified time limit
session and ResultSet.getDouble
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015