Creating MySQL database

Creating MySQL database on Linux system

1. I assume that you are working from your account and not the root. Start a terminal session and become the superuser (Type su at the prompt and then enter the root password).


2. Now we'll access the MySQL server. Type:
   
   
   

   mysql -u root -p
   

   The system prompts for the MySQL root password that you set up in Installing MySQL on Linux. (Note: This is not the Linux root password but the MySQL root password). Enter the password, which is not displayed for security reasons.
   
   Once you are successfully logged in, the system prints a welcome message and displays the mysql prompt ... something like
   

   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 1 to server version: 3.22.32
   
   Type 'help' for help.
   
   mysql>
   

3. Now we are ready for creating the employees database. Issue the command:
   

   
   create database employees;
   

   (Note: The command ends with a semi-colon)
   


4. An important point to note is that this database is created by the root and so will not be accessible to any other user unless permitted by the root. Thus, in order to use this database from my account (called manish), I have to set the permissions by issuing the following command:
   

   GRANT ALL ON employees.* TO manish@localhost IDENTIFIED BY "eagle"
   

   The above command grants my account (manish@localhost) all the permissions on employees database and sets my password to eagle. You should replace manish with your user name and choose an appropriate password.


5. Close the mysql session by typing quit at the prompt. Exit from superuser and come back to your account. (Type exit).


6. To connect to MySQL from your account, type:
   

   mysql -u user_name -p
   

   Type in the password when prompted. (This password was set by the GRANTS ALL... command above) . The system displays the welcome message once you have successfully logged on to MySQL. Here is how your session should look like:
   

   
   [manish@localhost manish]$ mysql -u manish -p
   Enter password:
   Welcome to the MySQL monitor.  Commands end with ; or \g.
   Your MySQL connection id is 3 to server version: 3.22.32
   
   Type 'help' for help.
   
   mysql>
   
   

   
   


7. Typing the command SHOW DATABASES; will list all the databases available on the system. You should get a display similar to:
   
   

   
   mysql> SHOW DATABASES;
   +----------------+
   | Database       |
   +----------------+
   | employees      |
   | mysql          |
   | test           |
   +----------------+
   3 rows in set (0.00 sec)
   

   
   


8. Enter quit at the mysql> prompt to come out of the mysql client program.

Get all table name in oracle

If you are using Microsoft SQL Server you can use one of these queries.

SELECT *
FROM sys.tables

or

SELECT *
FROM sysobjects
WHERE xtype = 'U'

---

If you are using Oracle, you can use one of these:

SELECT *
FROM all_tables;

or

SELECT *
FROM all_objects
WHERE object_type = 'TABLE';

Hibernate Add Sort

import org.hibernate.Criteria;
import org.hibernate.Hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Expression;
import org.hibernate.criterion.Order;


if (status!=null){
Criteria criteria = oSession.createCriteria(com.vidasprint.core.pojo.K_KCLASS.class);
criteria.addOrder(Order.asc( "CLASSNAME" ).ignoreCase());
oK_KClass_List = criteria.add(Expression.in("STATUS", status)).list();

} else{
Criteria criteria = oSession.createCriteria(com.vidasprint.core.pojo.K_KCLASS.class);
criteria.addOrder(Order.asc( "CLASSNAME" ).ignoreCase());
oK_KClass_List = criteria.list();

}

Auto expand/adjustable iframe

Below is some javascript code that will automatically expand the iframes that we currently use to embed forms.
(1) Paste The blow to the head

<script language="JavaScript">
<!--
function calcHeight()
{
//find the height of the internal page
var the_height=
document.getElementById('the_iframe').contentWindow.
document.body.scrollHeight;

//change the height of the iframe
document.getElementById('the_iframe').height=
the_height;
}
//-->
</script>

(2)Paste the code below to the body and replace "your page here" with your url

<iframe width="100%" id="the_iframe"
onLoad="calcHeight();"
src="your page here"
scrolling="NO"

frameborder="0"
height="1">
An iframe capable browser is
required to view this web site.
</iframe>

Parent call iframe function

document.getElementById("userFrame").contentWindow.submitForm();

Infofusion : clear db

cmd prompt:

infoload db02 -create -force -file NUL


(clear and create database named db02, force to create, and with empty file)

Oracle : Create User

example:create sample2_clean
at Aqua application:

--create user
Create user sample2_clean identified by password
go
--grant access
grant connect to sample2_clean
go
grant resource to sample2_clean
go
grant create any snapshot to sample2_clean
go
grant sysdba to sample2_clean
go