PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural language extension for SQL.
A very easy one for someone, The following insert is giving me the ORA-01722: invalid number why? INSERT INTO CUSTOMER …
sql oracle plsql casting type-conversionIn SQL I (sadly) often have to use "LIKE" conditions due to databases that violate nearly every rule of normalization. …
sql sql-server oracle tsql plsqlI tried the following code different ways, like by taking out the while or the if, but when I put …
sql oracle if-statement plsql while-loopI'd like to create an in-memory array variable that can be used in my PL/SQL code. I can't find …
oracle plsql oracle9iWhat is the difference between SQL, PL-SQL and T-SQL? Can anyone explain what the differences between these three are, and …
sql tsql plsqlIs it possible to search every field of every table for a particular value in Oracle? There are hundreds of …
sql oracle search plsql database-tableWhen executing the following code, it just says the procedure is completed and doesn't print the infomation i want it …
plsql oracle10g sqlplus dbms-outputI wanted to delete some unused schemas on our oracle DB. How can I query for all schema names ?
oracle plsqlI have a PL/SQL function (running on Oracle 10g) in which I update some rows. Is there a way …
oracle plsql sql-update