To copy table across databases/schemes. Oracle SQLplus Copy Command: SQL> create table table_name as select * from table_name; SQL> copy from usr/pwd@SID to usr/pwd@SID create table table_name as select * from table_name; Drop Constraint Example:– ALTER TABLE Employee DROP CONSTRAINT constraint_name; – ALTER TABLE Employee disable/enable CONSTRAINT constraint_name; ADD Constraint Examples – …
1- Is domain name taken <?php $recordexists = checkdnsrr(“www.yahoo.com”, “ANY”); if ($recordexists) echo “The domain name has been taken. Sorry!”; else echo”The domain name is available!”; ?> 2- Get IP address <?php $ip = “204.71.200.75”; $host = “www.yahoo.com”; $verify_ip = gethostbyaddr($ip); $verify_name = gethostbyname($host); echo “$ip resolves to $verify_ip”; echo “$host resolves to $verify_name”; ?> …
Syntax: – CREATE [SHARED][PUBLIC] DATABASE LINK link_name [CONNECT TO user IDENTIFIED BY password] [AUTHENTICATED BY user IDENTIFIED BY password] [USING ‘connect_string’] – DR-OP DATABASE LINK Examples Using DB Links Choose one of the following SQL statement to create a Database link: 1- CREATE DATABASE LINK link_name CONNECT TO user IDENTIFIED BY password …
1- Opening and Reading a File Line by Line a- read Line by Line <html><body> <?php $filename = “test.txt”; $fp = fopen( $filename, “r” ) or die(“Couldn’t open $filename”); while ( ! feof( $fp ) ) { $line = fgets( $fp, 1024 ); print “$line<br>”; } ?> </body></html> a- read …
HTML Cohabitation HTML File HTML Font HTML String Hyperlink HTML Utilities: PageBreeze Form Builder. Free for personal use.(Windows) Forms To Go by BEBO Soft. Create form-to-email scripts in PHP, ASP or Perl for your HTML forms. MacOS X or Windows. Arachnophilia by Paul Lutus. Successor to WebThing. A Java-based program that will …
FORM Form Action action=”<?php echo $_SERVER[‘PHP_SELF’]; ?>” action=”<?php echo $PHP_SELF ?>” <form method=”POST” action=”<?php echo $SCRIPT_NAME ?>”> <html><body> <form METHOD=”POST” ACTION=”GetFormValue.php”> Name: <input TYPE=”TEXT” NAME=”Name”/> Memo: <textarea NAME=”Comment” ROWS=”4″ COLS=”40″ WRAP=”PHYSICAL”> </textarea> <input TYPE=”SUBMIT”/> </form></body> <!– GetFormValue.php –> <?php echo “Name=$Name”; echo “Text=$Comment”; ?> Form based Email <form action=”sendemail.php” method=post name=form1> Name: …
Mit Perl und DBI + DBD-Oracle können unter z.B Oracle Datenbanken und viele andere Datenbanken angebunden werden und wird meistens für kleinere Projekte verwendet. Alle Module DBD-* und die Module für den anderen Datenbanken (Ingres, Informix, Adabas, uvam.) stehen im Internet unter jedem CPAN Mirror zu verfügung. Aktuelle Artikel zum Thema PERL …