The DBMS_UTILITY.COMPILE_SCHEMA procedure compiles all procedures, functions and packages in the specified schema. DBAs now don’t have to generate the dynamic scripts to recompile the invalid objects in the schema
PL/SQL supports three parameter-passing modes: IN
At some point, you must have encountered a “Snapshot too old” error when running a huge batch transaction. Then you find that you may have to restart the process all
If you are ever trying to write SQL to access SQL server’s system tables, it is often useful to look at SQL Server’s own system stored procedures. You can do
Question: How do I find out if a user has disabled cookies? Answer: To find out if a user has disabled cookies, follow these steps: Set a cookie. Redirect to
Question: I’m writing a select statement to make a table name a variable whose value is set according to a condition: Var tablename;tablename := emp tableselect * from tablename; But
Question: I need to extract information using WHERE on fields in two different tables: one a text field, the other a numeric field. Both hold only numeric data. How can
Question: Can you explain the interaction of the RS232 signals (RTS, CTS, DTR, etc.). I need to write a software utility to transmit and receive characters between two computers, but
Question: How do I concatenate a value in Stored Procedures (e.g., select * from mytable, where mytable.field1 = field that I concatenate)? Answer: If you want to match field1 to