Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
Delete from table statement is used in Sql to delete the rows in the table. It is a DML (Data Manipulation language) statement. It is used to delete the subset of existing rows or all existing rows from the table. we will looking at Oracle Sql syntax but this is valid for sql’s Here is the syntax Here table is the table name and condition … Continue reading Delete from table statement in Oracle
SSH is nice tool to connect to the server. it encrypts all traffic to eliminate eavesdropping, connection hijacking, and other attacks. I will be giving the steps for installing that on Ubuntu OS Step 1: First check if it is already running ps -ef |grep -i SSH Step 2: Now install the SSH using the command sudo apt-get install openssh-server -y Here are some issue … Continue reading How to install SSH on Ubuntu
These are 35 Most Useful command to help you manage the VPS (Virtual Private server) or Dedicated Server. This should help you in daily work on the server. I have included command for all major Linux distribution like CentOS ,Ubuntu 1)How to connect to Server using putty Download Putty here a)Provide Hostname or IP address of the VPS or dedicated server b) Choose SSH or telnet … Continue reading 35 Useful command to help you manage the VPS or Dedicated Server
Apache is the HTTP server which is freely available over internet. it is widely used on Linux distribution to host websites. Apache configuration is managed by the configuration file httpd.conf. You can use locate command to find the configuration file $ locate httpd.conf /etc/httpd/conf/httpd.conf After making the change , you need to restart the Apache services to make it effective Command for Linux version 4.x/5.x/6.x … Continue reading how to start and stop httpd service
MySQL is a open source database widely used in Industry. If the MySQL. is hosted on Linux platform,here are the steps to stop and start the MySQL. /etc/init.d/mysqld status The above gives the status of the mysql service /etc/init.d/mysqld stop The above gives the stop of the mysql service /etc/init.d/mysqld start The above gives the start of the mysql service /etc/init.d/mysqld restart The above gives … Continue reading How to start and stop mysql on Linux
Many times we need to change password on the remote desktop. And you find that when you press Ctrl + Alt + Del while in RDP, this is still passed to the local computer from where you have setup the Remote desktop connection. I have too encountered this issue recently and I did lot of research over it to find the various solution Here are … Continue reading How to change password on Remote desktop (RDP)
INSERT statement is a DML ( Data Manipulation Language) command . It is use to insert new rows into the tables Syntax INSERT INTO <table_name> (col1, col2, … column_n ) VALUES (value1, value2, … value_n ); Here table_name: Table where new records need to be inserted col1,col2 : are the column in the tables value1,value2….: are the values corresponding to col1,col2 …in the table Only … Continue reading Useful information about INSERT statement in Oracle
We receive this error while inserting data,creating index, table when we don’t have enough space in tablespace. Solution is to add sufficient space in the tablespace identified in the error. There are three ways to do it Add datafile Resize the existing datafile autoextent the datafile Each one is explained below with example below we can use ALTER TABLESPACE to add datafile in tablespace like Default Tablespace Syntax … Continue reading ORA-01652: unable to extend temp segment: Solutions
How to check tablespace in Oracle To list the names and various other of all tablespaces in a database, use the following query on the DBA_TABLESPACES view: SELECT TABLESPACE_NAME “TABLESPACE”, EXTENT_MANAGEMENT,FORCE_LOGGING,BLOCK_SIZE,SEGMENT_SPACE_MANAGEMENT FROM DBA_TABLESPACES; To list the Datafiles and Associated Tablespaces of a Database To list the names, sizes, and associated tablespaces of a database, enter the following query on the DBA_DATA_FILES view SELECT FILE_NAME, BLOCKS, … Continue reading How to check tablespace in Oracle Database
We sometimes have shrink the datafile to reclaim filesystem space. We can do it like Alter database datafile <datafile name > resize <smaller size>; Many times we may get the below error as the extent may spread out on the outer of the file ORA-03297: file contains used data beyond requested RESIZE value”. To resolve the error,We can find the true resize value for … Continue reading How to shrink the datafile in Oracle
-You alter or modify a table using the ALTER TABLE statement. -The table must be contained in your schema To alter a table, or you should either have ALTER object privilege for the table or the ALTER ANY TABLE system privilege. -If a view, materialized view, trigger, function-based index, check constraint, function, procedure of package depends on a base table, the alteration of the base table or its columns … Continue reading How to Alter Table in Oracle
-Oracle allows us create a temporary table. -The definition of a temporary table is visible to all sessions, but the data in a temporary table is visible only to the session that inserts the data into the table. -We have to use the CREATE GLOBAL TEMPORARY TABLE statement to create a temporary table. -The ON COMMIT clause indicates if the data in the table is transaction-specific (the default) or session-specific DELETE ROWS … Continue reading Creating a Global Temporary Table in Oracle