Author Archive

Create a shortcut to open an FTP site in Windows Explorer

  1. Open My Computer by clicking the Start button, and then clicking Computer.

  2. Right-click anywhere in the folder, and then click Add a Network Location.

  3. This displays the Add Network Connection wizard. Click Next.

  4. In the wizard, select Choose a custom network location, and then click Next.

  5. Enter the name of the FTP site, with the full FTP:// in front of it, and then click Next.

  6. To use a name and password, clear the Log on anonymously check box. Type a user name, and then click Next.

  7. By default, the name of the shortcut is the same as the FTP address. If you want to give the shortcut a different name, type it in the Type a name for this network location box. Click Next.

  8. If you do not want the FTP site to open after you're done setting up the shortcut, clear the Open this network location when I click Finish check box. Click Finish. A shortcut to the FTP site appears in the Computer folder. You can drag that shortcut to your desktop so that it's easy to find later.

Read more »

DROP multiple TABLE / TRIGGER / FUNCTON in oracle using PL SQL

To drop more than one tables having a matching criteria then we should use a PL SQL statement, in oracle there is a table called USER_OBJECTS having name of all the tables for that particular user.

DROP TABLE is a DDL statement so that we need EXECUTE IMMEDIATE privilege for dropping table from a script, more easy way to drop table is to generate DROP TABLE command using a script and run that command.

The following PL SQL script generate drop table command for all tables having table name contains  word 'test'

SET SERVEROUTPUT ON;

DECLARE
  object_name varchar2(100);
  cursor cur1 is SELECT object_name FROM user_objects WHERE object_type='TABLE' AND object_name LIKE '%test%';
BEGIN

  open cur1;
  loop
        fetch cur1 into object_name;
        exit when cur1%notfound;
      dbms_output.put_line('DROP TABLE ' || object_name || ';' );
    end loop;
    close cur1;

END ;

Output

anonymous block completed

DROP TABLE USER_TEST;

Read more »

Find table names and column names inside a database using oracle

Display all table names in a database

select * from tab;


Display number of tables in a database

select count(*) from tab;


Find table exits in a database

select * from tab where tname like '%STUDENT%';


Display all column names in a database

select * from USER_TAB_COLUMNS;


Display number of columns in a database

select count(*) from USER_TAB_COLUMNS;


Find column name exits in a database

select * from USER_TAB_COLUMNS where COLUMN_NAME like '%STUDENT_ID%';


Find column name exits on a table in a database

select * from USER_TAB_COLUMNS where TABLE_NAME like '%STUDENT%' and COLUMN_NAME like 'STUDENT_ID';


 

Read more »