Shutdown Another Computer:
=======================
In cmd mode write , shutdown -i
then give computer name or ip ,then comments then ok.
Hack Wi/Fi:
=======================
In cmd mode;
write wmic,
then quit.
then netsh wlan show profiles
then netsh wlan show profiles (wi/fi name like SQUARE)
then netsh wlan show profiles SQUARE Key=clear
in key content password will show.
cain & abel software is needed for wi/fi password hack.
Message Box Creation:
=====================
x=MsgBox("Message Description",0+64,"Title")
x=Msgbox("You are hacked",1+64,"alamin")
x=Msgbox("please contract your administrator",3+64,"alamin")
in notepad and save it as vbs file.
CMD:
===========================
color a
cls
title alamin command
write , "do a barrel roll" in google search and see.
xcopy d:\java e:\
xcopy d:\java e:\ /i [i=copy folder with subfolder]
robocopy \\192.168.0.27\Al_Amin\alamin o:\test\ /MIR /LOG:o:\test\M.log
To copy contents of C:\UserFolder to C:\FolderBackup:
Robocopy C:\UserFolder C:\FolderBackup
To copy all contents including empty directories of SourceFolder to DestinationFolder:
Robocopy C:\SourceDir C:\DestDir /E
List only files larger than 32 MBytes(33553332 bytes) in size.
Robocopy.exe c:\sourceFolder d:\targetfolder /min:33553332 /l
Move files over 14 days old (note the MOVE option will fail if any files are open and locked).
ROBOCOPY C:\SourceFoldern D:\DestinationFolder /move /minage:14
/MIR is an option to ROBOCOPY where you mirror a directory tree with all the subfolders including the empty directories and you purge files and folders on the destination server that no longer exists in source.
ROBOCOPY \\sourceserver\share \\destinationserver\share /MIR
Or
ROBOCOPY source-drive:\DIR destination-drive:\DIR /MIR
The following command will mirror the directories using Robocopy:
Robocopy \\SourceServer\Share \\DestinationServer\Share /MIR /FFT /Z /XA:H /W:5
Use Robocopy to copy all changes to files in a directory called c:\data to a directory that contains the date, like data_20091124. Create a batch file as follows.
@echo off
set day=%date:~0,2%
set month=%date:~3,2%
set year=%date:~6,4%
Robocopy "c:\data" "c:\backup\data\%day%-%month%-%year%\" /MAXAGE:1
To mirror the directory "C:\directory" to "\\server2\directory" excluding \\server2\directory\dir2" from being deleted (since it isn't present in C:\directory) use the following command:
Robocopy "C:\Folder" "\\Machine2\Folder" /MIR /XD \\server2\ directory\dir2"
You have copied the contents from source to destination but now you made changes to the Security permissions at source. You wanted to copy only the permission changes and not data.
ROBOCOPY <Source> <Target> /E /Copy:S /IS /IT
To copy a directory tree along with the source timestamps for folders
Robocopy C:\Folder1 C:\Folder2 /MIR /dcopy:T
To copy a directory using /IPG to limit bandwidth usage. General rule of thumb /IPG:750 will use roughly 1Mbps.
Robocopy /ipg:750 /z /r:3 /w:3 /tee /LOG+:c:\robolog.txt //server1/share //server2/share
Mysql:
go to root folder where mysql installed.
cd C:\xampp\mysql\bin
mysql -u root -p -h 127.0.0.1
show databases;
create database userlogin;
use userlogin;
show tables;
Before Report Trigger:
==================
function BeforePForm return boolean is
begin
srw.message(100,'before parameter form trigger');
return (TRUE);
end;
About Dual:
========================
Without Dual:
=========================
create procedure sys_date is
v date;
begin
v:=sysdate;
dbms_output.put_line(v);
end;
create function sys_date_func return date is
v date;
begin
v:=sysdate;
return v;
end;
About Index:
========================
When you restore a table from the recycle bin, dependent objects such as indexes do not get their original names back; they retain their system-generated recycle bin names. You must manually rename dependent objects if you want to restore their original names.
ALTER INDEX "BIN$DBo9UChtZSbgQFeMiAdCcQ==$0" RENAME TO IDX;
usefull link:
http://psoug.org/reference/constraints.html
alter system kill session 'sid,serial#';
select SID,SERIAL#,USER#,USERNAME,OWNERID,SERVER,MACHINE from v$session;
SQL * LOADER:
===============
load data
truncate
into table farid2
fields terminated by " " optionally enclosed by "#"
(EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
EMAIL,
PHONE_NUMBER,
HIRE_DATE,
JOB_ID ,
SALARY ,
MANAGER_ID,
DEPARTMENT_ID )
sqlldr userid=hr/hr@ala data='E:\ALAMIN_DESKTOP\290516\data.txt' control='E:\ALAMIN_DESKTOP\290516.loa.ctl' bad='E:\ALAMIN_DESKTOP\290516\b.bad'
Listner Check
===============================
In cmd mode run : lsnrctl status orcl
and
In cmd mode insert into lsnrctl
then
status,start,stop
=======================
In cmd mode write , shutdown -i
then give computer name or ip ,then comments then ok.
Hack Wi/Fi:
=======================
In cmd mode;
write wmic,
then quit.
then netsh wlan show profiles
then netsh wlan show profiles (wi/fi name like SQUARE)
then netsh wlan show profiles SQUARE Key=clear
in key content password will show.
cain & abel software is needed for wi/fi password hack.
Message Box Creation:
=====================
x=MsgBox("Message Description",0+64,"Title")
x=Msgbox("You are hacked",1+64,"alamin")
x=Msgbox("please contract your administrator",3+64,"alamin")
in notepad and save it as vbs file.
CMD:
===========================
color a
cls
title alamin command
write , "do a barrel roll" in google search and see.
xcopy d:\java e:\
xcopy d:\java e:\ /i [i=copy folder with subfolder]
robocopy \\192.168.0.27\Al_Amin\alamin o:\test\ /MIR /LOG:o:\test\M.log
To copy contents of C:\UserFolder to C:\FolderBackup:
Robocopy C:\UserFolder C:\FolderBackup
To copy all contents including empty directories of SourceFolder to DestinationFolder:
Robocopy C:\SourceDir C:\DestDir /E
List only files larger than 32 MBytes(33553332 bytes) in size.
Robocopy.exe c:\sourceFolder d:\targetfolder /min:33553332 /l
Move files over 14 days old (note the MOVE option will fail if any files are open and locked).
ROBOCOPY C:\SourceFoldern D:\DestinationFolder /move /minage:14
/MIR is an option to ROBOCOPY where you mirror a directory tree with all the subfolders including the empty directories and you purge files and folders on the destination server that no longer exists in source.
ROBOCOPY \\sourceserver\share \\destinationserver\share /MIR
Or
ROBOCOPY source-drive:\DIR destination-drive:\DIR /MIR
The following command will mirror the directories using Robocopy:
Robocopy \\SourceServer\Share \\DestinationServer\Share /MIR /FFT /Z /XA:H /W:5
Use Robocopy to copy all changes to files in a directory called c:\data to a directory that contains the date, like data_20091124. Create a batch file as follows.
@echo off
set day=%date:~0,2%
set month=%date:~3,2%
set year=%date:~6,4%
Robocopy "c:\data" "c:\backup\data\%day%-%month%-%year%\" /MAXAGE:1
To mirror the directory "C:\directory" to "\\server2\directory" excluding \\server2\directory\dir2" from being deleted (since it isn't present in C:\directory) use the following command:
Robocopy "C:\Folder" "\\Machine2\Folder" /MIR /XD \\server2\ directory\dir2"
You have copied the contents from source to destination but now you made changes to the Security permissions at source. You wanted to copy only the permission changes and not data.
ROBOCOPY <Source> <Target> /E /Copy:S /IS /IT
To copy a directory tree along with the source timestamps for folders
Robocopy C:\Folder1 C:\Folder2 /MIR /dcopy:T
To copy a directory using /IPG to limit bandwidth usage. General rule of thumb /IPG:750 will use roughly 1Mbps.
Robocopy /ipg:750 /z /r:3 /w:3 /tee /LOG+:c:\robolog.txt //server1/share //server2/share
Mysql:
go to root folder where mysql installed.
cd C:\xampp\mysql\bin
mysql -u root -p -h 127.0.0.1
show databases;
create database userlogin;
use userlogin;
show tables;
Before Report Trigger:
==================
function BeforePForm return boolean is
begin
srw.message(100,'before parameter form trigger');
return (TRUE);
end;
About Dual:
========================
DROP TABLE SYS.DUAL ;
Table dropped.
CREATE TABLE SYS.DUAL(DUMMY VARCHAR2(1 BYTE)
TABLESPACE SYSTEM;
Table created.
CREATE PUBLIC SYNONYM DUAL FOR SYS.DUAL;
Synonym created.
GRANT SELECT ON SYS.DUAL TO PUBLIC WITH GRANT OPTION;
Grant succeeded.
INSERT INTO dual VALUES ('X');
1 row created.
SQL> SELECT * FROM dual;
D
-
X Without Dual:
=========================
create procedure sys_date is
v date;
begin
v:=sysdate;
dbms_output.put_line(v);
end;
create function sys_date_func return date is
v date;
begin
v:=sysdate;
return v;
end;
About Index:
========================
When you restore a table from the recycle bin, dependent objects such as indexes do not get their original names back; they retain their system-generated recycle bin names. You must manually rename dependent objects if you want to restore their original names.
ALTER INDEX "BIN$DBo9UChtZSbgQFeMiAdCcQ==$0" RENAME TO IDX;
usefull link:
http://psoug.org/reference/constraints.html
alter system kill session 'sid,serial#';
select SID,SERIAL#,USER#,USERNAME,OWNERID,SERVER,MACHINE from v$session;
SQL * LOADER:
===============
load data
truncate
into table farid2
fields terminated by " " optionally enclosed by "#"
(EMPLOYEE_ID,
FIRST_NAME,
LAST_NAME,
EMAIL,
PHONE_NUMBER,
HIRE_DATE,
JOB_ID ,
SALARY ,
MANAGER_ID,
DEPARTMENT_ID )
sqlldr userid=hr/hr@ala data='E:\ALAMIN_DESKTOP\290516\data.txt' control='E:\ALAMIN_DESKTOP\290516.loa.ctl' bad='E:\ALAMIN_DESKTOP\290516\b.bad'
Listner Check
===============================
In cmd mode run : lsnrctl status orcl
and
In cmd mode insert into lsnrctl
then
status,start,stop
lsnrctl status
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন