Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between SQL and SQL*PLUS?
- 1 Answers
- 2952 Views
- I also Faced
- E-Mail Answers
Answer / nishi
SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle database.
SQL is a language used to query the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query result, Set options, Edit SQL commands and PL/SQL.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a nvl function? How can it be used?
Explain what are the advantages of views?
What are the components of logical database structure in oracle database?
What is Trigger in Oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is a proxy object?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How can you use check constraints for self referential integrity?
find out first highest salary?
10 Answers Verinon Technology Solutions,
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
How to load data from external tables to regular tables?
What are advantages fo Stored Procedures?
Oracle General 
