QueryCAT Logo
Search 5,000,000+ questions and answers.

Frequently Asked Questions

What is SQL*Plus?

CIS Oracle FAQ
SQL*Plus is the Oracle command line utility. You can access it on gradient or eniac by typing "sql" (provided you have set it up correctly)

Does SQL Server have an 'ON ERROR RESUME' type function in TSQL to match the VB facility?

Environment settings set by a batch file are not working.
Why do I get the error 'Cannot use file <logfile> because it was originally formatted with a different sector size See similar questions...

Can I use SQL function in a BizField?

F.A.Q. | PHPOpenBiz
For example, <BizField Name="FullName" Column="" SQLExpr="CONCAT([FirstName],' ',[LastName])"...> See similar questions...

How do I get help in SQL*Plus?

CIS Oracle FAQ
SQL*Plus has a nice help system. Just type "help" or "help <command>" for help on a specific command. See similar questions...

How do I run a script in SQL*Plus?

CIS Oracle FAQ
A script with SQL or SQL*Plus commands in it should have the extension ".sql". E.g. your script is called "foo.sql" to run it type "start foo" or "start foo.sql". See similar questions...

Why is my JDBC or SQL*Plus hanging?

CIS Oracle FAQ
You need to add "setenv EPC_DISABLED TRUE" to your Oracle startup script or profile. This is a problem in the server. How can I see all my tables? SQL> select table_name from tabs; or SQL> select table_name from user_tables; (tabs is actually a public synonym for user_tables). See similar questions...

Do I have access to my database with SQL Plus?

Oracle Hosting FAQ
You can do imports and exports using the Oracle Client software, which we distribute to users; however, you do not have ftp access to the servers that an account is on. You can also do a db link from your existing account to your new account. What is the configuration of the servers upon which the databases are running? Primarily, is their sufficient horsepower to run multiple Oracle Databases on a single computer, and does that server have a RAID based Disk Capacity. See similar questions...

How do I implement a Logout function?

ASU IT: WebAuth
The recommended solution is to use the WebAuth logout call: https://weblogin.asu.edu/cgi-bin/login?Logout&onLogoutURL=http://www.asu.edu. Just replace the onLogoutURL value with the page you want the user redirected to upon logout. This call will clear any references (e.g. credential file) on the WebAuth server, in addition to clearing the browser cookie. The Kerberos credential lifetime is set to 9 hours on the WebAuth servers. The cookie lifetime is for the browser session ? only. See similar questions...

I run my PL/SQL through SQL*Plus but I dont see anything? Why ?

Oracle & Financial Applications (pl/sql sql apps faq links c...
Before you Execute the PL/SQL do the following: SQL> set serveroutput on SQL> execute xxxxxxxxxxxxxx.xxxxxxxxxxx; dont forget the semicolon CREATE OR REPLACE PACKAGE BODY apps_ar_forms_dup_trackcm AS select line, text from user_source where upper(name) = upper('&PLSQL_NAME') order by line Click Database, then Schema Browser, wait a few minutes. Then click the PROCS tab and look for your FUNCTION, PROCEDURE or PACKAGE. click here for a screen print example See similar questions...

I can SELECT from SQL*Plus but not from PL/SQL. What is wrong?

PL/SQL FAQ - Oracle FAQ
PL/SQL respect object privileges given directly to the user, but does not observe privileges given through roles. The consequence is that a SQL statement can work in SQL*Plus, but will give an error in PL/SQL. Choose one of the following solutions: Grant direct access on the tables to your user. Do not use roles! GRANT select ON scott.emp TO my_user; Define your procedures with invoker rights (Oracle 8i and higher); create or replace procedure proc1 authid current_user is begin ... See similar questions...

Is there a PL/SQL Engine in SQL*Plus?

PL/SQL FAQ - Oracle FAQ
No. Unlike Oracle Forms, SQL*Plus does not have an embedded PL/SQL engine. Thus, all your PL/SQL code is sent directly to the database engine for execution. This makes it much more efficient as SQL statements are not stripped off and sent to the database individually. See similar questions...

The update functions aren't SQL. How do I implement them?

TPC-D Frequently Asked Questions (FAQ)
Because they are intended to reflect updates to a decision support system (using either periodic bulk refresh or an ongoing background task), the implementor is allowed significant flexibility in this area. The update functions delete old rows from, and insert new rows into the order and lineitem tables. See similar questions...

Windows SQL*Plus is not showing all my extended characters?

A Detailed Look at the NLS_LANG Parameter
You see black squares instead of the characters you probably don't have the right font defined for your codepage. A font is a collection of glyphs (from "hieroglyphs") that share common appearance (typeface, character size). A font is used by the operating system to convert a numeric value into a graphical representation on screen. A font does not necessarily contain a graphical representation for all numeric values defined in the code page you are using. See similar questions...

How can I implement my collision callback as a C++ member function?

FAQ - ODE Wiki
How can I simulate a servo motor? dReal Gain = 0.1; dReal MaxForce = 100; dReal TruePosition = dJointGetHingeAngle(joint); dReal DesiredPosition = /* whatever */; dReal Error = TruePosition - DesiredPosition; dReal DesiredVelocity = -Error * Gain; dJointSetHingeParam(joint[a], dParamFMax, MaxForce); dJointSetHingeParam(joint[a], dParamVel, DesiredVelocity); The Gain and MaxForce parameters can be tuned to get the desired stiffness and strength from the joint. See similar questions...

Is it possible to return a set of results from SQL*Plus to a UNIX variable ?

The Oracle (tm) Users' Co-operative FAQ - Index
How do I translate UNIX shell into NT Batch, e.g. echo "set time on; \n exec pl_sql_program; \n exit" | sqlplus uid/pswd See similar questions...

What about SQL?

Coastline - ASP FAQ
We support MySQL on our newest servers. If you would like to use MySQL and are unsure whether it is available to you or not, please contact Customer Support. If you do not have MySQL available to you, we would be happy to switch your server so you can use it. See similar questions...

How do we implement this system?

FAQ
Monitoring of some environmental indicators take places regularly (for air quality, waste, water and so on). Yes. Training sessions have been organized by the ISO14001 Steering Group in November 1999, August 2000, December 2000 and November 2001. Records can be found on the UNU ISO14001 Online Forum. The training materials are also available on the UNU ISO14001 Online Forum. See similar questions...

What is SQL? Where can I learn SQL?

Mckoi SQL Database - Frequently Asked Questions (FAQ)
SQL stands for Structured Query Language. It has become the standard for manipulating and querying data in a relational database. SQL is widely taught in higher education CS courses. There are several books and online tutorials that teach SQL. See similar questions...

Explore Other Topics

what age should I have my pet spayed or neutered?
Where can I get data on Libor and other market interest rates?
QUESTION: Are there any steroids or any bonded substance in Ringmaster Rubbing Oil?
Is genetic modification synonymous to biotechnology ?
How do I extract text from a (Javascript) message box?
What is an R-value?
Can I purchase a remote car starter for a manual transmission vehicle?
How much meat can I get from a deer?
Can I use these products if I am pregnant or nursing?
What scripting language is QTP of?
What was Abraham Lincoln's hat size? What is the top hat made of?
How do I know if the duvet will fit inside the duvet cover?
What is Actual Cash Value (ACV)?
What is the PSP (.psp) image format?
What do I need to bring when picking up my new puppy?
More Questions >>

© Copyright 2007-2012 QueryCAT
About • Webmasters • Contact