Author: Awais Farooq
-
Oracle ALTER TABLE Statement
In Oracle, ALTER TABLE statement specifies how to add, modify, drop or delete columns in a table. It is also used to rename a table. How to add column in a table Syntax: Example: Consider that already existing table customers. Now, add a new column customer_age into the table customers. Now, a new column “customer_age”…
-
CREATE TABLE AS Statement
The CREATE TABLE AS statement is used to create a table from an existing table by copying the columns of existing table. Note: If you create the table in this way, the new table will contain records from the existing table. Syntax: Create Table Example: copying all columns of another table In this example, we…
-
Oracle CREATE TABLE
In Oracle, CREATE TABLE statement is used to create a new table in the database. To create a table, you have to name that table and define its columns and datatype for each column. Syntax: Parameters used in syntax Oracle CREATE TABLE Example Here we are creating a table named customers. This table doesn’t have…
-
What is Oracle?
Oracle database is a relational database management system (RDBMS) from Oracle Corporation. This article will explain a complete overview of the Oracle database, features, history, and editions. Before discussing the oracle, we will first need to know about the database. What is a database? A database refers to the organized collection of structured data stored electronically in…
-
Oracle Tutorial
Oracle tutorial provides basic and advanced concepts of Oracle. Our Oracle tutorial is designed for beginners and professionals. Oracle is a relational database management system. It is widely used in enterprise applications. Our Oracle tutorial includes all topics of Oracle database such as insert record, update record, delete record, select record, create table, drop table…
-
Complete Working Example
In this chapter, we will learn how to create a complete MVC based BookStore application in FuelPHP. Step 1: Create a project Create a new project named “BookStore” in FuelPHP using the following command. Step 2: Create a layout Create a new layout for our application. Create a file, layout.php at location fuel/app/views/layout.php. The code…
-
Unit Testing
Unit testing is an essential process in developing large projects. Unit tests help to automate the testing of the application’s components at every stage of development. It alerts when the component of the application is not working according to the business specification of the project. Unit testing can be done manually but is often automated. PHPUnit FuelPHP…
-
Error Handling & Debugging
FuelPHP provides an excellent support for handling the errors and debugging the application. Let us understand error handling and debugging in this chapter. Error Handling FuelPHP error handling is based on exceptions. FuelPHP provides PhpErrorException exception for all old php errors. FuelPHP raises PhpErrorException whenever an error in the PHP code is encountered. FuelPHP also…
-
Profiler
Profiler is one of the important tools to analyze and improve the performance of the application. FuelPHP provides an excellent profiler to profile the application. Let us learn about the profile in FuelPHP in this chapter. Enable Profiling Profiling is disabled by default. To enable profiling, set the attribute profiling to true in the main configuration…
-
Email Management
Email functionality is the most requested feature in a web framework. FuelPHP provides an elegant email class bundled as a package. It is used to send simple plain text email as well as advanced rich text email with multiple attachments. It supports the following features – Plain-text mails, HTML mails, attachments, and inline attachments. Configuration…