TOAD

Crystal Reports Cannot query View

I cannot query result from my custom Database View created from TOAD SQL, anyone knows why? I have granted access for the user.

Oracle PL/SQL Toad for Oracle-How to make editor generate a script for tables,views,packages so that the script can be searched

Hello, I am using "Toad for Oracle" and i am trying to find a way to search for certain words and numbers in the comments in scripts. I know you could use the create a script button and then control f to search for the words in the script. But is their a way to do it using a query or to create a...

Database report output shows multiple pages

When I run a report, I see multiple pages, but running the query directly on the database using TOAD gives me only one record. How do I find why the query gives multiple pages? I can ofcourse set printing option as "First Page" for all the fields, but I need to know why the duplication occurs.

Multiple Tables to Bulk Import .sql script

I am a very new user to both SQL and Oracle and I am hoping that someone can explain to me if there is a way to multiple tables in a schema to .sql Import scripts. I know that in TOAD, you can right click on a table and choose export from the list, then save it as an .sql file. If I select...

connect sys as sysdba

how to connect sys as sysdba in toad software and in isqlplus. When i tried in isqlplus and in toad by connecting as "sys as sysdba" i got the error. please give me a solution.

I'm not able to use hints in my tables

I'm not able to use hints in my tables. TOAD is treating it as comment I think. Do I need to do some setting.????