Does truncate free space?
No Answer is Posted For this Question
Be the First to Post Answer
Can you load data into multiple tables at once? : aql loader
How to look at the current sql*plus system settings?
Which kind of parameters cannot have a default value in pl sql?
how to create object in plsql
I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.
what is autonomouse transaction?
We have a CURSOR then we need BULK COLLECT?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query
Explian rowid, rownum?
What is %s in sql?
What are triggers and its uses?
Oracle (3259)
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)