Oracle sql plsql spool file for practice from Sathish Yellanki morning 7am batch

Hi friends
i have unlocked all the oracle sql, plsql files and it is in the same order no files are missing.
so enjoy practicing sql and plsql.

You can even take print out also because i unlocked all the files.

click this link for sql, plsql files :ORACLE_SQL_PLSQL

 

one of the most respected and unique faculty for oracle

how to crack protected pdf or how to copy and edit from protected pdf

Often its tough to crack protected pdf, here protected pdf means pdf that is not allow you to edit or copy or it is a password protected pdf.

so how to crack??
follow these simple steps
download this tool and extract the folder and install it.
tool.rar

after that open any pdf and unlock.

HOW TO CREATE DEMO TABLES IN ORACLE OR HOW TO CREATE TABLES THAT ARE PRESENTED IN SATHISH YELLANKI SIR SYSTEM

How to create demo tables.
actually its a script that is save as .sql extension just use the @(special character for running script from specific location in your system using sqlplus).

First what you need is the demo script.
Download it from this below link........

demobld.sql

after downloading save it in your drive.
ok now we will execute this script using oracle.
first copy this script in a folder and always care the folder name or path name don't have any space otherwise oracle will not read your script from your specific location.
now open sqlplus or on cmd prompt type sqlplus
give username and password
now write like this
SQL >@path_of_file_with_name
for example
SQL >@D:\oracle\sql\demobld.sql and hit Enter key
if every thing goes well your database is ready with these tables.

SQL> SELECT Tname FROM TAB;

TNAME
----------------
DUMMY
DEPT
EMP
BONUS
SALGRADE
CUSTOMER
ORD
ITEM
PRODUCT
PRICE