Topic: BASIC Toad Pl SQL Commands
Not finding your answer? Try searching the web for BASIC Toad Pl SQL Commands
Answers to Common Questions
what are the basic commands i needed to know to work in unix plat...
Hi Anu, You will need to know all the basic Unix commands. See the following sites - In addition, you can go through the following site which explains calling sqlplus through unix - Hope this helps. Regards Suchitra Read More »
Source: http://en.allexperts.com/q/Oracle-1451/2009/12/unix-shell-scripti...
How to get similar results? PL/SQL output on TOAD
open a new sql editor and then run your pl/sql code. The bottom portion of the toad where you see the results when you a execute a normal sql query has a tab called 'DBMS Output'. Just click on this tab after executing your pl/sql code. Tha... Read More »
Source: http://www.experts-exchange.com/Database/Oracle/3rd_Party_Tools/Q...
How to execute a command in PL/SQL
Use Native Dynamic SQL (Execute Immediate) sysntax execute immediate cmd Read More »
Source: http://www.experts-exchange.com/Q_20150710.htm
More Common Questions
Answers to Other Common Questions
DDL's can be called in the PL/SQL using Dynamic Query. If ur oracle version is prior to 8i, then use DBMS_SQL package.. if its 8i, use EXECUTE IMMEDIATE
Read More »
Source: http://www.experts-exchange.com/Database/Oracle/Q_20440114.html
if your database is running on windows you can do it with external procedure calls, with java stored procedure or with dbms_scheduler, or with .net plugin stored procedures note, these will run on the server only. no code on the database se...
Read More »
Source: http://www.experts-exchange.com/Q_24142973.htm
Try using this sql statement: INSERT INTO campaign (Campaign_Name, GM_Email) VALUES ('" & campaignName & "', '"& gmEmail & "')"
Read More »
Source: http://www.experts-exchange.com/Q_20536736.htm
http://plsql-tutorial.com/
Read More »
Source: http://answers.yahoo.com/question/index?qid=20100204230617AAuMRzO
try looking up PERL or SQL tutorials.
Read More »
Source: http://uk.answers.yahoo.com/question/index?qid=20090303080057AAzl...
Hi, you can execute os commands using DBMS_PIPE package. Write a program that reads an Oracle pipe (using C or another language) and send messages to pipe in PL/SQL using a proc like below. Your C program should read pipe and execute statem...
Read More »
Source: http://www.experts-exchange.com/Q_20898740.htm
A is the answer. you insert the reocrds into Locations and departments. but you do not commit it.
Read More »
Source: http://www.experts-exchange.com/Q_20900154.htm
