Tip Bank

The LIKE statement is often used in SQL queries with wildcards to find data that issimilar to a matching pattern. PL/SQL has two forms of wildcard: _ and %. The

You often encounter requirements for reports to retrieve the top-n/first-n rows of a table

In a nested procedure environment, I have often felt the need to isolatethe transactions of the child/called procedure from the parent/calling procedure’s transactions. Until Oracle8i, it used to be a

Use Cascading Style Sheets to create a floating text paragraph. First, add the attribute in the document’s section: Now, add the content you want to display in the window: Visit

Checking whether a table exists in a Microsoft SQL Server database is easy. You can use this query: SELECT ‘x’FROM sysobjectsWHERE type = ‘U’ and NAME = ‘mytable’ But this

In Microsoft SQL Server, you frequently need to navigate through data row by row. This is usually done using T-SQL server-side cursors. Considering that processing overhead on cursors is higher

Question: I have a date field store in one of my database tables. How do I pull a record from that table within seven days of today’s date? today’s date

Question: Is there a way to store data in an Excel file from an ADO recordset by doing some sort of block read/write instead of reading/writing every data field in

Question: Can I use Oracle’s PL/SQL in Visual FoxPro or SQL Server 6.0? Answer: No. PL/SQL is a language native to Oracle, not Microsoft’s products. Each Microsoft database product has