Basic functions such as query, insert and update records are essential for anyone working with databases, but other action also has a great value, deleting records.
In the Oracle database that action is performed using the DELETE command, as shown in the following syntax:
DELETE FROM [Table]
We will delete all products in a table using this command to illustrate its use.
DELETE FROM products
The above command will delete all records from the table and therefore needs to be used very cautiously, thinking to avoid problems in the bank is that the DELETE command is used along with conditional WHERE.
DELETE FROM products
WHERE cod_prod= 1
Using the above code only the record that satisfies the condition is cleared, so there is no possibility to delete a record by mistake.
The Oracle database has become very popular over the years and it has been common to find them in projects, especially the WEB using the PHP language. Learn the advantages of using Oracle with PHP projects WEB accessing our official site.
Oracle is one of the most respected DBMS in the world, created in the late 70s by Lary Ellison, quickly turned into one of the most used and trusted. Your security scheme and processing capacity were some of the features that gave it that title. One of the great advantages of Oracle has always been a pioneer in several features for databases, one of the firsts to think about a model for the web in the late 90s.It is very common to find the database Oracle working with PHP applications in development environments.
As it is a powerful DBMS, it is common to see projects using Oracle. Several types of applications work using it, so that it is very common to find large PHP projects that need to connect with this type of database. But depending on the tool used to develop the application, the connection may have problems. An external driver that may be used to make the connection may require development hours until it works perfectly. In addition, issues related to security of the connection (data access) also can be a problem.
Therefore it is essential to have a tool that can assist you in this aspect. With Scriptcase you can easily connect to Oracle database, all you need to inform to connect to the Oracle is:
- Connection Name: It will help you identify the connection among the others.
- DBMS Driver: it Will show a list with all drivers available.
- TSNAME: Should be informed the IP of the server where the database is installed and the instance name created in the Oracle installation.
- Port: The port that you want to use to connect to your database.
- Username: Username for the user from the database.
- Password: The password from the previous selected username.
Once you connect Scriptcase with your database, it will read your tables and create applications based on the desired tables. Scriptcase will identify all special characteristics from your table, such as primary keys, foreign key, auto-increments, among others, and will show that at the application level. All the CRUD (Create, Read, Update and Delete) actions will be managed by the Scriptcase. On forms and reports all the navigation, searches and filters (Static or Dynamic) will be also handled by Scriptcase automatically.
Scriptcase support stored procedures and all SQL statements (joins, order by, group by, among others) of Oracle, why lose time when you have Scriptcase to help you out?! Download it now and test it free for 20 days!