CS HOT TOPICS: October 2014

Tuesday, October 28, 2014

how to import database into oracle?

Import schemas(table,view,trigger,cursor etc.) into Oracle:

There are two ways to import shcemas.
1. Using Directory
2. Without using Directory

1. Using Directory:-

Step i.

Create a folder at first in any drive.

Step ii.

Open SQL prompt and create a directory using given syntax:

SQL> create directory directory-name as folder-name

where directory-name is any name and folder-name must be what you've created in step 1.

Step iii.

Exit from sql prompt and write import command at command prompt using given synatx:

C:\> impdp User/password dumpfile=file-name.dmp directory=directory-name remap_schema=Old User:New User

where User is user-name with import privilege, password is the password for that user, file name is exported dump file name with extension .dmp, directory-name is the same name what you created in step ii. and for remap_schema, old user is the user for which you exported already the schema(table, view, function etc.) and NewUser the user for which u want to import database.

Friday, October 24, 2014

how to export database in oracle?

Export schemas(table,view,trigger,cursor etc.) from Oracle:

There are two ways to export shcemas.
1. Using Directory
2. Without using Directory

1. Using Directory:-

Step i.

Create a folder at first in any drive.

Step ii.

Open SQL prompt and create a directory using given syntax:

SQL> create directory directory-name as folder-name

where directory-name is any name and folder-name must be what you've created in step 1.

Step iii.

Exit from sql prompt and write export command at command prompt using given synatx:

c:\> expdp User/password dumpfile=file-name.dmp directory=directory-name schemas=User

where User is user-name with export priviledge, password is the password for that user, dump file name is any file name with extension .dmp, directory-name is the same name what you created in step ii. and schemas user is for which you want to export schemas(tables, views, function etc.)

Example:-

Here is the exported dump file:

2. Without using Directory:

Remove (directory=directory-name) attribute from step iii above. So, syntax would be like this:

Syntax:

C:\>expdp user/password dumpfile=dump-file-name schemas=User

This time the dump file location would be default location of oracle. I'm using 10g express edition so my default file location is 'c:\oraclexe\app\oracle\admin\xe\dpdump\dump-file.dmp'. Default location may vary according to version. On command prompt see the 2nd line from last. This is your default dump-file location.

Example:

Friday, October 17, 2014

how to create dynamic table?

Sometimes ago, when i was developing a Web Application then i'd need to create dynamic table. I did google but nothing found useful for me. Then i decided to develop it by myself. Although it took some great time but yes, the outcome was fabulous.
Here is the code.

Dyntable.js

function getVal()
{
var val=document.frm.txt1.value
var str="<table border='2'><tr> 
<th nowrap='nowrap'><font color='blue' size='2'>Item 1</font></th>
<th><font color='blue' size='2'>Item 2</font></th>
<th><font color='blue' size='2'>Item 3</font></th> 
</tr>" 
//validation logic for each table's cell 
var b=0;
while(val>0)
{
str=str+"<tr><td>
<input type='text' name='jtext"+ ++b 
+"' onBlur='if(isNaN(this.value)){ 
alert(\"value must be numeric !!!\") 
} 
else if(this.value<=0) 
{ alert(\"Value must be greater than zero !!!\") 
} '/></td><td><input type='text' name='jtext"+ ++b 
+"' onBlur='if(isNaN(this.value)){ 
alert(\"value must be numeric !!!\") } 
else if(this.value<=0) { 
alert(\"Value must be greater than zero !!!\") 
} '/></td><td>
<input type='text' name='jtext"+ ++b +"' 
onBlur='if(isNaN(this.value)){ 
alert(\"value must be numeric !!!\") } 
else if(this.value<=0) { 
alert(\"Value must be greater than zero !!!\") } '/>
</td></tr>";
val--;
} 
str=str+"</table>"; 

document.getElementById("spn").innerHTML=str;
}

Htmlcode.html

<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Dynamic table</title>
</head>
<script language="javascript" src="Dyntable.js"> </script>
<body>
<center>
<h1>Dynamic table</h1>
<form name="frm">
<input type="text" size="20" name="txt1">
</br></br>
<input type="button" value="ok" name="okbtn" onclick='getVal()'>
</form>
<p>
<span id="spn"></span>
</center>

</body>
</html>

Here is Output:

Saturday, October 11, 2014

what is php?

ABOUT PHP:

PHP (recursive acronym for PHP: Hypertext Preprocessor) is a widely-used open source server-side scripting language that is especially suited for web development and can be embedded directly into HTML. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features. The goal of the language is to allow web developers to write dynamically generated pages quickly.

As of January 2013, PHP was installed on more than 2.1 million web servers. PHP was Originally developed by Rasmus Lerdorf in 1994. PHP code can be simply mixed with HTML code, or it can be used in combination with various templating engines and web frameworks.

PHP VERSION:

VERSION	RELEASED DATE
1.0	8 June 1995
2.0	1 November 1997
3.0	6 June 1998
1.7	July 19, 2011
2.5	January 24, 2012
3.0	September 27, 2012
4.0	22 May 2000
4.1	10 December 2001
4.2	22 April 2002
4.3	27 December 2002
4.4	11 July 2005
5.0	13 July 2004
5.2	2 November 2006
5.3	30 June 2009
5.4	1 March 2012
5.5	20 June 2013

SYNTAX:

The following Hello world program is written in PHP code embedded in an HTML document:

<!DOCTYPE html>
<html>
    <head>
        <title>PHP Test</title>
    </head>
    <body>
        <?php echo '<p>Hello World</p>'; ?>
    </body>
</html>

Friday, October 10, 2014

how to install joomla?

Installing Joomla!

Download the Joomla! 3.0.x full package at http://www.joomla.org/download.html
Create a new folder entitled “Joomla30” in folder “htdocs” in XAMPP folder. Normally it will be located at “C:\xampp\htdocs”
Unpack the downloaded package file into the folder “Joomla30”
Go to the URL “http://localhost/Joomla30”
Follow all steps in Joomla! installation:

Step 1. Main Configuration

Select Language: Choose your own language in the drop-down menu, for example, “English (United States)”
Site Name: Enter the name of your site
Description: Enter the description of your site
Site Offline: Choose status for your website when you access to your site: Click “Yes” for “offline” and “No” for “online”
Admin Email: Enter your valid email address you want to use for your site
Admin Username: Enter “admin” as default
Admin Password: Enter your own password
Confirm Admin Password: Re-type your password
Click “Next” to continue Step 2

Step 2. Database Configuration

Database Type: Select MySQLi
Host Name: Enter “localhost”
Username: Enter “root”
Password: let it blank
Database Name: enter the name of the database you created “Joomla30”
Table Prefix: let it generate automatically
Old Database Process: Click “Backup” to backup tables from former Joomla! installation, or “Remove” to delete these tables
Click “Next” to continue Step 3

Step 3. Overview

Finalization: You can choose installing sample data or not, by clicking on corresponding selection.
Overview: This step is to review all information you configured in step 1. After checking, you click “Install”.
When installation finishes, you just need to click the button “Remove installation folder” button to complete the installation process. After that, you can either click on “Site” to see your newly created or “Administrator” to access the administration area.

Now you have installed your Joomla! site successfully!

Sunday, October 5, 2014

what is joomla?

ABOUT JOOMLA:

Joomla was released on September 22, 2005. It is one of the most popular free content management systems (CMS) in the world that allows you to easily create and manage a dynamic website. It has an interface to control all the features and functionality this powerful CMS possesses. Furthermore, there are hundreds of free extensions written for Joomla that allows users to extend its functionality and customize it to their own objectives.

It is built on a model–view–controller web application framework that can be used independently of the CMS. Joomla is written in PHP, uses object-oriented programming (OOP) techniques (since version 1.5) and software design patterns. stores data in a MySQL, MS SQL (since version 2.5), or PostgreSQL (since version 3.0) database, and includes features such as page caching, RSS feeds, printable versions of pages, news flashes, blogs, polls, search, and support for language internationalization.

As of 2013, Joomla has been downloaded over 50 million times. Over 7,700 free and commercial extensions are available from the official Joomla! Extension Directory, and more are available from other sources.

JOOMLA VERSION:

VERSION	RELEASED DATE
1.0	September 22, 2005
1.5	January 22, 2008
1.6	January 10, 2011
1.7	July 19, 2011
2.5	January 24, 2012
3.0	September 27, 2012
3.1	April 24, 2013
3.2	November 6, 2013
3.3	April 30, 2014
3.4	September 2014

Take a look of joomla 3:

ABOUT ME