How to run sql statements with oracle sql developer?
No Answer is Posted For this Question
Be the First to Post Answer
I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.
table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004
what is the command for user data type?
Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.
How do I view a table in sql?
Explain the significance of the & and && operators in pl sql.
How to test for null values?
Why commit is not used in triggers?
how to create a new view in mysql? : Sql dba
what is the different between unique+not null & primary key,
What is the maximum number of columns in sql table?
Where the sql database files are stored?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)