0
The syntax for dynamic sql is
For example if you want to create table at run time then syntax is
Declare
V-string varchar2(900);
begin
V_string:='create table ORACLE (empno number,ename varchar2(90)');
execute immediate V_string;
end;
/
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What is syntax errors in sql server 2005?
wrong sql syntax in your query
Which Oracle software uses SQL server tools?
SQL Server Tools are tools for the Microsoft SQL Server (MSSQL). Oracle is another company that develops database systems and offer Oracle tools to manage Oracle databases.
What are the differences between SQL statement to iSQL plus statement?
Structured Query Lanaguage(SQL) is a command language to communicate with oracle server.whereas SQL*PLUS is an oracle tool that recognises and submits sql statements to the oracle server for execution.
Difference between sql and sql plus?
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
Examples for dbms and rdbms?
My sql, Microsoft sql , Microsoft Access, dBase, Filemaker pro are the examples for dbms and oracle and sql server are the examples for rdbms
What is deffirence between sql server 2005 and oracle?
oracle runs on any platform whereas sql server runs only on windows.
What is the purpose of an oracle developer?
An oracle developer like "Oracle SQL" is used for modelling in computing. It's a data modeller for working in SQL. It provides reporting, tuning and unit testing.
Can any one tell best site for Oracle Apps Technical training?
Oracle Apps Techno Functional Faculty: Oracle Apps Technical, Oracle Apps Functional, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K.
What are the differences between Oracle and SQL?
Oracle is an RDBMS aka Relational Database Management System and SQL (Structured Query Language) is a programming language.
What is Oracle SQL Developer software used for?
Oracle SQL Developer software is a free development environment software package. It enables users to develop software applications using Java for Oracle databases.
What has the author Bijoy Bordoloi written?
Bijoy Bordoloi has written: 'Oracle SQL' -- subject(s): Oracle (Computer file), SQL (Computer program language)
List out the dbms softwares?
*Altibase *Oracle * SQL server * Fox Pro * MS-Access * Sequel-Pro(mac)
